How to Manage WordPress Users

How to Reset a WordPress Users Password using SQL?

You can quickly set a WordPress users password to the new ‘somenewpassword’ text as seen below, assuming that the user login is ‘theirusername’. Change the username and password to whatever you’d like and execute the query.

  UPDATE wp_users 
  SET user_pass = MD5( 'somenewpassword' ) 
    WHERE user_login = ‘theirusername’;

How to Get a List of Subscribers?

The below example will get a list of registered users who are assigned the role of subscriber:

  SELECT wp_users.ID, wp_users.user_nicename, wp_users.user_email
  FROM wp_users 
  JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id 
    WHERE wp_usermeta.meta_key = 'wp_capabilities'
      AND wp_usermeta.meta_value like '%subscriber%'
  ORDER BY wp_users.user_nicename;

Conclusion

Now that we’ve gone over how to manage WordPress Users by using SQL, check out some of our other knowledge base articles.

KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team is ready to help you with requests should you need our assistance. You’re not using KnownHost for the best web hosting experience? Well, why not? Check with our Sales team to see what can KnownHost do for you in improving your web hosting experience