User and Database Management

Command syntax will vary between MySQL Versions 
 ==================================================================================== 
 User Management 
 Show all users and hosts 
 SELECT user, host FROM mysql. user; 
 Add User 
 CREATE USER 'name'@'localhost' IDENTIFIED BY 'password.'; 
 Granting Privileges 
 Available privileges: 
 
 
 
 CREATE 
 Allows the user to create new databases and tables. 
 
 
 ALTER 
 Allows the user to alter (modify) existing tables. 
 
 
 DROP 
 Allows the user to drop (delete) databases and tables. 
 
 
 INSERT 
 Allows the user to insert new rows into tables. 
 
 
 UPDATE 
 Allows the user to update existing rows in tables. 
 
 
 DELETE 
 Allows the user to delete rows from tables. 
 
 
 SELECT 
 Allows the user to read (select) data from tables. 
 
 
 REFERENCES 
 Allows the user to create foreign key constraints when defining tables. 
 
 
 RELOAD 
 Allows the user to execute the FLUSH statement, which reloads various server configurations and clears or refreshes caches. 
 
 
 
 Grant specific privilege ( or multiple comma separated): 
 GRANT PRIVILEGETYPE ON database.table TO 'username'@'host';
FLUSH PRIVILEGES; 
 Grant all: 
 GRANT ALL ON database.table TO 'username'@'host';
FLUSH PRIVILEGES; 
 Delete a user 
 DROP USER 'name'@'host'; 
 Change user password 
 ALTER USER 'user'@'host' IDENTIFIED BY 'NewPassword';
FLUSH PRIVILEGES; 
 ==================================================================================== 
 Database Management 
 Create a database 
 CREATE DATABASE name; 
 ------------------------------------------------------------------------------------------------------------------------------------------------ 
 Delete a database 
 DROP DATABASE name; 
 ====================================================================================