mysql.md

Login

mysql -u <username> -p

List all users

select User, Host from mysql.user;

Show databases

show databases;

Change user password

set password for '<username>'@'<host>' = password('<password>');

Grant user privileges

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

Show user privileges

SHOW GRANTS FOR 'user'@'localhost';

Export a database

mysqldump -u <username> -p <databasename> > file.sql