This post may contain affiliate links, please read our affiliate disclosure to learn more.
How to Reset a WordPress User’s Password From Within MySQL

How to Reset a WordPress User’s Password From Within MySQL

 By Charles Joseph | Cybersecurity Researcher
 Published on December 26th, 2023

In WordPress, user passwords are stored in a database table named “wp_users.” This table contains 10 fields, each holding different types of user information. These fields are:

  • ID
  • user_login
  • user_pass
  • user_nicename
  • user_email
  • user_url
  • user_registered
  • user_activation_key
  • user_status
  • display_name

To reset a user’s password, you’ll need to use a specific command in MySQL that updates the password for a chosen user.

NordVPN 67% off + 3-month VPN coupon

Stay One Step Ahead of Cyber Threats

Want to Be the Smartest Guy in the Room? Get the Latest Cybersecurity News and Insights.
We respect your privacy and you can unsubscribe anytime.

When using this command, replace <username> with the actual username of the account you want to reset.

Also, if your WordPress installation uses a table prefix different from the default “wp_” make sure to replace “wp_” with your custom prefix.

Here’s the command:

This command changes the password for the specified user to ‘new_password.’

Remember to replace ‘new_password’ with the actual password you want to set.

"Amateurs hack systems, professionals hack people."
-- Bruce Schneier, a renown computer security professional
Scroll to Top