denrepo

MySQLSecurity & users

Accounts with SUPER or GRANT privilege

Accounts that can administer the server or hand out privileges, plus whether they're locked.

Not yet verified. How scripts are tested

b-my-users.sql 
1SELECT user, host, Super_priv, Grant_priv, account_locked2FROM mysql.user3WHERE Super_priv = 'Y' OR Grant_priv = 'Y'4ORDER BY user, host;

Paste it into your query tool.

Open in denrepo