How to reset your WordPress user password in the database via phpMyAdmin

It’s relatively easy to reset your WordPress password by editing the password field in the database.

CAUTION: Making mistakes here can break your site, if you are unsure get your web developer to assist. It’s recommended you make a backup of your database before proceeding.

Reset your user password

1. Login to your control panel e.g. cPanel.
2. In the Databases section > phpMyAdmin, you are not redirect to the phpMyAdmin page.
3. In phpMyAdmin in the left pane, find the database for your WordPress site and click on it. (CAUTION: make sure you have the correct database).
4. Both left and right panes will now populate. In the left pane find the Users table, it will usually look something like “wzs_users” and click on it.
5. A list of users is now listed in the right pane. Click the Edit link.
6. In the user_pass big text box type a simple password you’ll remember easily.
7. Click the dropdown box and select MD5 option.
8. Scroll to the bottom of the page and click the Go button to save the changes.

You’ve now updated your WordPress user password. You can now proceed to the WordPress login page and login using the newly reset password, but there’s more…

Ensure your password is secure

IMPORTANT: Once logged in, reset your password to something secure, the WordPress suggested password is recommended. To do this:

1. In the WordPress dashboard, in the top right corner hover over your profile and click Edit Profile.
2. Scroll down and click Set New Password, make sure to copy and save that new password in a secure place.
3. Then at the bottom click Update Profile to update to the new secure password.

Congratulations, you have now reset your WordPress user password by editing the database using phpMyAdmin.