How to Reset or Change WordPress Password through phpMyAdmin

In our daily life, we all have many passwords. After all, we  are human beings, so sometimes we forget our passwords.

But what will happen if you forget your WordPress blog’s password or your site got hacked and you cannot reset your password using your email? It will be very difficult for you to login to admin dashboard.

Don’t worry guys you can reset your WordPress administrator password through PhpMyAdmin. This method will help you reset or change WordPress password.

Reset your WordPress Password through phpMyAdmin

change wordpress admin password smallenvelop

Every WordPress Installation has MySQL Database which you can access via PhpMyAdmin.

You will need to Know the exact name of your WordPress database but don’t get upset if you don’t know the name of  your WordPress database.

Just go to  your root directory and edit wp-config.php file in any editor like Notepad++.  Here you will find your WordPress database name.

Once you find the name of the database, follow the below steps to reset your WordPress password through phpMyadmin.

  • Open Your  CPanel, go to the databases section and click on phpMyAdmin.
  • Now, click on you WordPress database name and open the wp_users table.
  • In this table, you will find “user_login” and “user_pass”. That is what we’re only looking for.  Now, you need to change your Password in “User_pass” section.

Note:- Because of security purposes you will not be able to enter plain text as password, you will need to encode your password with MD5 Hash.

  •  To convert Plain Text into MD5 hash, use this Javascript MD5 tool. Just enter your text and convert. Once done, copy the MD5 code and paste in “User_pass” section.
  • After pasting your password just save it.

All done! You have now successfully changed the WordPress password throughPhpMyAdmin. I hope this article will help you.

Here is a video tutorial by WPbeginner

For any queries please feel free to comment.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.