Questions? Feedback? powered by Olark live chat software

Are you having a problem resetting your password through your email? Do you want to get another way to do it easier? This article is for you. Today, we will show you how to reset your password directly from phpMyAdmin. Let follow us and do it step by step!

Why you should use phpMyAdmin to reset your WordPress password.

As you know, one of the easiest ways to reset your password is simply accessing the login screen and taking a click on the “Lost your password” link.

After clicking on this link, you will go to the password reset page. On this page, you are able to type your username and your email address as well in order to recover your password. Waiting for a few seconds, there will be a password reset link sending directly to your email dress connected with that user account.

But there is a normal problem that you can not reset your password if your WP site fails to send an email or you are not able to get to your email address. So in this circumstance, it is necessary for you to reset your password in the database directly. And using phpMyAdmin is one of the easiest ways that you can do.

Now, let’s follow our introduction to be able to reset your WordPress password from phpMyAdmin in an easy way!

How to use phpMyAdmin to recover your WordPress Password

Step 1: Log in to the cPanel dashboard of your WP hosting account and then click on the phpMyAdmin icon below the database section.

The phpMyAdmin app will appear.

Step 2:  In this place, you have to choose your WordPress database.

Step 3: Navigate to the ‘{table-prefix}_users’ table and click on the ‘Browse’ link close to it.

Note: Remember that the table names in the WP database may have another table prefix, not always the one you see in our screenshot.

Step 4: It will have many rows in your WordPress users table. Let click on the edit button close to the username which you want to recover your password.

A form including all user information fields will be displayed in phpMyAdmin.

Step 5: Remove the value in the user_pass field and then type your new password. Alter the function to MD5 from the drop-down menu below the function column and click on the Go button.

If you have finished 5 steps above, we congratulate that you have changed your WP password successfully. Your new password has encrypted with the MD5 had and it stored in your WordPress database.

Why select the MD5 hash to encrypt the password.

It is the fact that there are some of you who are wondering the reason why we choose MD5 hash to encrypt the password.

As you know, in the later WordPress version, MD5 hash is used to encrypt passwords. However, from WordPress version 2.5, it stared using other stronger encryption technologies. But WordPress still confirm MD5 to offer backward compatibility.

Therefore, if you log in with a password string that is stored as an MD5 hash, WordPress swill realize and alter it by using the newer encryption algorithms.


That is all of our introduction and we hope that it can help you to reset your WordPress password from phpMyAdmin. During resetting your password, if having any question, please leave a comment below, we will answer you quickly.

Leave a Reply

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

[Flash Sale] Grab 20% OFF for everything on Today! Get PRO Version for your theme!
[Flash Sale!] Get 25% OFF for your purchase on today! Coupon code: FLASH25 Join Membership Now