[DataBase] mysql & mariadb 계정생성 및 원격권한

mysql :  

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';
CREATE USER 'react'@'%' IDENTIFIED BY '1234';
GRANT ALL PRIVILEGES ON *.* TO 'react'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

 

mariadb:

ALTER USER 'root'@'localhost' IDENTIFIED BY '1234';
CREATE USER 'react'@'%' IDENTIFIED BY '1234';
GRANT ALL PRIVILEGES ON *.* TO 'react'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;