How to find WordPress admin users over mysql command line

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

Similar Posts:

Leave a Reply

Your email address will not be published.