Sometimes the Lost Password retrieval tool in WordPress doesn’t work due to an error in your host. In that case, phpMyAdmin helps you to change the wordpress user password by editing the database. phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin is a free software. So, most of the hosting providers use phpMyAdmin to allow their customers to handle databases.
Let’s see how to change the wordpress password using this tool. First go to your hosting control panel and open phpMyAdmin. Then select your wordpress database.
Then click on (wp)_users table.
Now click on Browse.
Select the wordpress username and click Edit.
If you look at the user_pass row, you’ll see a string with random characters in the Value field. It is your encrypted old password. WordPress never stores your password in plain text in your database. This procedure is followed to protect your password from crackers. So, clear it.
Now, type your new password in Value field, and select MD5 in the Function dropdown. This encrypts your new password again.
Finally select Save and hit Go button.
Now, you’ll see a message appearing above the tables saying that 1 row affected. This indicates that the password has been changed successfully.
You can now login to your wordpress site using the new password.
Follow these topics WordPress