Skip to content

How do I reset my WordPress User password via PHP myAdmin?

Reset-Wp-admin-password-via-php-my-admin

Updating the password using phpMyAdmin (cPanel / CloudPanel / Plesk)

If you’d like to use the traditional method to update password, you can update WordPress user passwords directly from the database using phpMyAdmin: 

  • Go to phpMyAdmin.
  • Select Log In for the database where the core WordPress installation is located.
  • Select to expand the database tables on the left-hand side and locate the wp_users table.
  • Locate the row with the user you wish to update the password for and select Edit.
  • Locate the row with Column ID user_pass, select MD5 in the function dropdown, and enter your new password in the Value field. 
  • Select Go and your password will now have updated. 

Having issue with text explanations? Please see the step by step method with screenshot below.

As an example I’m using CloudBegan hosting to reset wp user via PHP MyAdmin, so please follow the same steps if you are using other control panels like cPanel and Plesk

1. Open control panel (CloudPanel / cPanel / Plesk), and select “PHP MyAdmin

2. Access PHP MyAdmin Panel and click to Users

You may see the different syntax before users as you can see (a5_), so don’t worry just to find “_user” and click.

3. Once you cick to user, you will get edit option – Click to “Edit

4. Locate the row with Column ID user_pass, select MD5 in the function dropdown, and enter your new password in the Value field. 

5. Scroll down, Select Go and your password will now have updated. 

Now you can use this new password to login WordPress dashboard via “wp-admin”

Thank you !

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments