How to show WordPress admin user using mysql command prompt
select * from wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID where meta_value like '%administrator%';
or
SELECT u.ID, u.user_login, u.user_nicename, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID WHERE m.meta_key = 'wp_capabilities' AND m.meta_value LIKE '%administrator%' ORDER BY u.user_registered;
Watch your DB prefixes!
Source: https://wordpress.stackexchange.com/questions/249309/how-do-i-find-all-admin-users-using-phpmyadmin