Commands

------------------------------------------------------------------------------------------------------------------------------------------------

Add User

CREATE USER 'name'@'localhost' IDENTIFIED BY 'password.';

------------------------------------------------------------------------------------------------------------------------------------------------

Create a database

CREATE DATABASE name;

------------------------------------------------------------------------------------------------------------------------------------------------

Granting Privileges

Available privileges:

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD

Grant specific privilege ( or multiple comma separated):

GRANT PRIVILEGE ON database.table TO 'username'@'host';

or

Grant all:

GRANT ALL ON database.table TO 'username'@'host';

------------------------------------------------------------------------------------------------------------------------------------------------