MySQL Cheat Sheet

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;