Knowledgebase

How to Reset WordPress Password from phpMyAdmin Print

  • Reset, wordpress, Password, phpMyAdmin, Reset wordpress, how to, wordpress password
  • 0

1. Log into the cPanel user interface to Reset WordPress Password from phpMyAdmin

How to Reset WordPress Password from phpMyAdmin | Gotmyhost

2. Search phpMyAdmin or Click phpMyAdmin from the Databases section

This will launch the phpMyAdmin app where you need to select your Word-Press database.

How to Reset WordPress Password from phpMyAdmin | Gotmyhost

3. Look for your Word-Press database

You will now see the list of tables in your Word Press database. You need to look for the wpwk_users table in this list and click on the Browse link next to it.

How to Reset WordPress Password from phpMyAdmin | Gotmyhost

Note: Table names in your Word Press database may have a different prefix than the one we are showing in our screenshot.

4. Now you will see the rows in your Word Press users table. Go ahead and click on the edit button next to the username whose password you wish to change.

How to Reset WordPress Password from phpMyAdmin | Gotmyhost

5. PhpMyAdmin will show you a form with all the user information fields.

You will need to delete the value in the user pass field and replace it with your new password. Under the function column, select MD5 from the drop-down menu and then click on the Go button at the bottom of the form.

How to Reset WordPress Password from phpMyAdmin | Gotmyhost

Your password will be encrypted using the MD5 hash and then it will be stored in the database.

That’s it! You should be able to log into your Word press Dashboard under the new password now. 


Was this answer helpful?
Back