Mysql

• 핸드북:Technical(으)로 돌아가기

MySQL hack book.

Create DB

MariaDB [(none)]> create database $DBNAME;

Create User

MariaDB [(none)]> create user '$user'@'localhost' identified by '$password';
MariaDB [(none)]> grant all privileges on *.* to '$user'@'localhost';
MariaDB [(none)]> flush privileges;

MariaDB [(none)]> create user '$user'@'localhost' identified by '$password';
MariaDB [(none)]> grant all privileges on $DBNAME.* to '$user'@'localhost';
MariaDB [(none)]> flush privileges;