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

Community Questions