If you want to reset your WordPress password through phpMyAdmin, most likely you don’t have access to your admin email and you cannot reset your password through a standard option. There is a simple way to do it in your WordPress database. Read further to learn how to reset a WordPress password from phpMyAdmin.
Log in to your cPanel dashboard of your WordPress hosting account. After you will need to find your phpMyAdmin under the database section.
If you don’t remember a your user name or a password from database, phpMyAdmin, check your config.php file. There you can find a username and a password of your database. Like this you are sure which one to check.
Log in to your database and find the one for users.
Note! wp_users file can have a different name. Example: wp_mysitenameusers, wp_somethingusers
Select the user you would like to reset a password for and click EDIT.
You have to change a value for user_pass. Choose Function MD5 and put your new password for a value. After click GO.
Your password will be encrypted using the MD5 hash and then it will be stored in the database. Don’t be afraid if you see some random letters and numbers instead of your password. It is just encrypted.
Now you have successfully reset your WordPress password using phpMyAdmin. Try to login to your WordPress admin panel.
I hope you liked the article and it helped you to reset a WordPress password from phpMyAdmin.