In part I of this series, I showed you how to restore or recover your WordPress password using the MySQL command line. This time, I’ll show you how to do it with phpMyAdmin.
Note: use phpMyAdmin at your own risk. If you are not sure on how to use it, seek further advice. I’m not responsible for any loss of data.
1. Open phpMyAdmin.
2. Click on the drop down menu and select your WordPress database.
3. From the list of tables, look for the wp_users table and click on the Browse icon. (the prefix may defer with different databases)
4. Click on the Edit icon (pen icon).
5. Look for the md5 hash of user_pass under the Value column.
6. Change the md5 hash with the one you created earlier. If you want to use a different username, you may also change the present value with a new one.
7. Close phpMyAdmin
8. Login to your WordPress blog with your new password (and username if you changed it).
I hope this series would provide you with the needed information on how to restore or recover your WordPress password. Some of you might know a totally different way of recovering WordPress user passwords, so any suggestions and corrections would be greatly appreciated.