MySQL cheatsheet

mysql-cheatsheet.md

Manage databases

Create database

CREATE DATABASE database;

Delete database

DROP DATABASE database;

Manage users

Create user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Delete user

DROP USER 'username'@'localhost';

Permissions

Types of permissions

• ALL PRIVILEGES
• CREATE
• DROP
• DELETE
• INSERT
• SELECT
• UPDATE
• GRANT OPTION

Grant permissions

GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';

GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;

Revoke permissions

REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;

Show permissions

SHOW GRANTS username;

Flush privileges

FLUSH PRIVILEGES;

Thank you 👌