MySQL Cheat Sheet

Login to MySQL Server

$ mysql -h <hostname> -u <username> -p <database_name>

List All MySQL Databases

mysql> show schemas;

List MySQL Users

mysql> SELECT user FROM mysql.user;

Create New User

mysql> CREATE USER 'newusername' IDENTIFIED BY 'password';

Grant Spesific Permission Into Spesific Tables for User

mysql> GRANT SELECT, INSERT, UPDATE ON dbname.tablename TO 'username' WITH GRANT OPTION;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON dbname.tablename TO 'username' WITH GRANT OPTION;