Difference between revisions of "MySQL Cheat Sheet"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
'''Create New User''' | '''Create New User''' | ||
| − | mysql> CREATE 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, DEELTE ON dbname.tablename TO 'username' WITH GRANT OPTION; | ||
Revision as of 22:28, 19 July 2022
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, DEELTE ON dbname.tablename TO 'username' WITH GRANT OPTION;
