Last Updated on March 23, 2020 by WS Content Team

In this article today, we will give you an introduction of how to reset your WordPress Password directly from PHPMyAdmin. In this way, you can detect the problem that you meet when resetting in a normal way like sending to your email address.

Why should you reset your WordPress password from phpMyAdmin?

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 you have to do to set your 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 followed 5 steps above, you have altered your WP password successfully. Your new password has encrypted with the MD5 had and it stored in your WordPress database.

Why do you 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.


We hope that it can help you to reset your WordPress password from phpMyAdmin. If you have any question during resting your password. Let leave a comment below, we will try to answer you quickly.

Leave a Reply

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