DB's and Users

Create a DB

CREATE DATABASE new_database;

Drop a DB

DROP DATABASE new_database;

Create a new user with all prems

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;

REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

FLUSH PRIVILEGES;

Check Grants

SHOW GRANTS FOR 'user'@'localhost';

SHOW GRANTS FOR CURRENT_USER();

Add user to 1 DB

GRANT ALL PRIVILEGES ON new_database . * TO 'newuser'@'localhost';

To drop a user:

DROP USER ‘newuser’@‘localhost’;