MySQL Query All Users and User Premissions

Use these commands in the mysql shell to get all mysql users and their permissions to databases:

# Get a list of users:
SELECT host,user,authentication_string FROM mysql.user;

# List Perms for a user:
SHOW GRANTS FOR 'user_name'@'localhost';

Example