Difference between revisions of "MySQL Cheat Sheet"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
mysql> GRANT SELECT, INSERT, UPDATE ON dbname.tablename TO 'username' WITH GRANT OPTION; | mysql> GRANT SELECT, INSERT, UPDATE ON dbname.tablename TO 'username' WITH GRANT OPTION; | ||
| − | mysql> GRANT SELECT, INSERT, UPDATE, | + | mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON dbname.tablename TO 'username' WITH GRANT OPTION; |
Revision as of 22:32, 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, DELETE ON dbname.tablename TO 'username' WITH GRANT OPTION;
