|
1 2 3 4 5 6 7 |
//For single instance //create user login ('localhost' || '%') CREATE USER 'MYDATABASE'@'localhost' IDENTIFIED BY 'Ddeemmoo1234!'; //set user permission all GRANT ALL PRIVILEGES ON MYDATABASE.* TO 'MYDATABASE'@'localhost'; //creat db CREATE DATABASE MYDATABASE; |
|
1 2 3 4 5 6 7 |
//For multiple instances //create user login ('localhost' || '%') CREATE USER 'MYDATABASE'@'%' IDENTIFIED BY 'Ddeemmoo1234!'; //set user permission all GRANT ALL PRIVILEGES ON MYDATABASE.* TO 'MYDATABASE'@'%'; //creat db CREATE DATABASE MYDATABASE; |