I need to find a way to list all database users that have
ALL PRIVILILEGES on
*.* (all databases and tables). Additionally, it would be great if it could also list only those with
My initial thought was to
select User from mysql.user where each privilege field is
="Y". That would result in a very long query. Is there another, more convenient way?