Skip to content

Instantly share code, notes, and snippets.

@vmi

vmi/list-accounts.sql

Created March 21, 2013 02:09
Show Gist options
  • Save vmi/5210189 to your computer and use it in GitHub Desktop.
Save vmi/5210189 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL listing accounts
Raw
list-accounts.sql
SELECT concat(User, '@', Host) User, Password FROM mysql.user order by host, user;
SELECT * FROM information_schema.schema_privileges order by table_schema, grantee, privilege_type;
SELECT * FROM information_schema.table_privileges order by table_schema, grantee, table_name, privilege_type;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment