Difference between revisions of "MySQL Cheat Sheet"
Jump to navigation
Jump to search
(Created page with "'''List MySQL Users''' mysql=# SELECT user FROM mysql.user;") |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | '''Login to MySQL Server''' | ||
| + | |||
| + | $ mysql -h <hostname> -u <username> -p <database_name> | ||
| + | |||
| + | '''List All MySQL Databases''' | ||
| + | |||
| + | mysql> show schemas; | ||
| + | |||
'''List MySQL Users''' | '''List MySQL Users''' | ||
| − | mysql | + | 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; | ||
Latest revision as of 17:53, 11 May 2023
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;
