Reset A Password on WORDPRESS website From phpMyAdmin

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.

user name or a password from database, phpMyAdmin
How to find a user name or a password from database, phpMyAdmin?
user name or a password from database, phpMyAdmin
How to find a user name or a password from database, phpMyAdmin?

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

How to find wp_users file in phpMyAdmin to reset a password for WordPress website?
How to find wp_users file in phpMyAdmin to reset a password for WordPress website?

Select the user you would like to reset a password for and click EDIT.

How to reset a password for WordPress website using phpMyAdmin?
How to reset a password for WordPress website using phpMyAdmin?

You have to change a value for user_pass. Choose Function MD5 and put your new password for a value. After click GO.

How to reset a password for WordPress website using phpMyAdmin?
How to reset a password for WordPress website using phpMyAdmin?

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.

Leave a Reply

Your email address will not be published. Required fields are marked *