How to Reset a WordPress Password from phpMyAdmin
Every WordPress blog or site uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using cPanel hosting. Follow these steps to reset your WordPress password using phpMyAdmin:
Step 1 – Identify the Name of your Database
It is always good to know the name of your WordPress Database. Sometimes you might be running multiple installations within the same database, then you will need to know exactly where to look for to reset the password. The best place to look is your wp-config.php file which is located in your root WordPress Directory. In there you will find the name of your database.
Step 2 – Locating Database and Editing the Fields
In your cPanel or other admin panel, you will need to access your MySQL database and then browse it via phpMyAdmin.
Once you are in phpMyAdmin, you will need to select the correct database on the left hand side. Look for the table wp_users, click on it and then click on the Browse Tab.
Click on the Pencil (Edit) Icon (or edit) to reset your Password.
Now you will see a field that looks like this:
Edit the user_pass field value. You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 Hash rather than Plain text. This means that you will not be able to enter plain text as the password without making sure you choose MD5 from the field to the left of that field as well.
Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive. Once you have done that, click the dropdown menu indicated below, and select MD5 from the menu.
Click the ‘Go‘ button to the bottom right.
Test the new password on the login screen. If it doesn’t work, check that you’ve followed these instructions exactly.
If all is well, then you have successfully changed your WordPress Password from within phpMyAdmin.