MySQL commands

CLI

mysql -u user -p

Access a database to work on

    USE database_name;
    SHOW TABLES;

You can show tables from a DB without switching to it

    SHOW TABLES FROM database_name;

Concatenate multiple repeated queries into a list for every table

SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME," COLLATE your_collation_name_here;") 
AS ExecuteTheString
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="YourDatabaseName"
AND TABLE_TYPE="BASE TABLE";

dump something prompting for password

mysqldump -u [user] -p [table] > [filename].sql

Restore from a dump file

mysql -u [user] -p [table] < [filename].sql

update something

UPDATE tablename  
SET column1 = value1, column2 = value2,
WHERE condition;

Get password policy

SHOW VARIABLES LIKE 'validate_password%';

Users

List all users for mysql

SELECT * FROM mysql.user;
SELECT User,Host FROM mysql.user;

Show a user’s permissions

SHOW GRANTS FOR '<user>'@'<host>';

Deletions

DROP DATABASE <DB_NAME>;

DROP USER <USER_NAME>@<HOST_NAME>;