MySQL#

Commands#

List databases#

SHOW databases;

List tables#

SHOW tables;

List users#

SELECT user FROM mysql.user;

Show logged in users#

SELECT user, host, db, command FROM information_schema.processlist;

Show current processes#

SHOW processlist;