CREATE USER: CREATE USER 'u'@'%' IDENTIFIED BY 'p'; : Add new database login account

ALTER USER: ALTER USER 'u'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'np'; : Change authentication method or password

DROP USER: DROP USER 'u'@'%'; : Remove user account

GRANT: GRANT SELECT,INSERT ON db.* TO 'u'@'%'; : Assign privileges

REVOKE: REVOKE INSERT ON db.* FROM 'u'@'%'; : Remove privileges

SHOW GRANTS: SHOW GRANTS FOR 'u'@'%'; : Display privilege statements for user

FLUSH PRIVILEGES: FLUSH PRIVILEGES; : Reload privilege tables after manual edits

SET PASSWORD: SET PASSWORD = PASSWORD('new'); : Change current user password

RESET MASTER: RESET MASTER; : Clear binary logs in replication master

KILL: KILL 1234; : Terminate running thread

SHOW PROCESSLIST: SHOW PROCESSLIST; : View active connections and queries

SHOW STATUS: SHOW STATUS LIKE 'Threads%'; : Check server status counters

SHOW VARIABLES: SHOW VARIABLES LIKE 'max_connections'; : Inspect configuration parameters

SHOW ENGINE INNODB STATUS: SHOW ENGINE INNODB STATUS; : Detailed diagnostics for InnoDB

PING: SELECT 1; : Test connection; server responds OK