Cheatsheet

Get information about DB / users

List databases

SHOW DATABASES;

List users

SELECT User FROM mysql.user;

View user permissions

SHOW GRANTS FOR 'root'@'localhost';

Manage users

Grant all privileges on DB

GRANT ALL PRIVILEGES ON testdb . * TO 'testuser'@'localhost';

Revoke all privileges

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testuser'@'localhost';

Revoke privileges on specific db

REVOKE ALL PRIVILEGES ON testdb . * FROM 'testuser'@'localhost';

Manage databases

Export

Using mysqldump tool

mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz]

Import

Simply execute the following command

::

gunzip < [compressed_filename.sql.gz] | mysql -u [user] -p[password] [databasename]

Note: There is no space between the keyword ‘-p’ and your password.