My SQL Server Level Grants
/* User-Specific Grants */ SELECT * FROM mysql.user;/* Database-Specific Grants */ SELECT * FROM mysql.db;/* Table-Specific Grants */ SELECT * FROM mysql.tables_priv;/* Column-Specific Grants */ SELECT * FROM mysql.columns_priv;
SELECT HOST, Db, USER, Insert_priv, Update_priv, Delete_priv, Create_tmp_table_priv, Alter_priv FROM mysql.db LIMIT 0,100;
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep';
or
show processlist;
1
KILL CONNECTION <processid>
