As you know, there are a lot of ways to reset your lost or hacked password in WordPress, and people normally reset it through the “Lost your password” link. However, sometimes your email isn’t working correctly. What can you do in this situation? Today, to help you solve this problem, we show you an easy way to reset a WP password directly from phpMyAdmin.
First, why reset your WordPress password from phpMyAdmin?
One of the easiest ways to reset your password is simply to go to the login screen and click on the “Lost your password” link.
After clicking on this link, you will go to the password reset page. On this page, you can type your username or email address to recover your password. After a few seconds, a password reset link will be sent directly to the email address connected with that user account.
But a common problem is that you cannot reset your password if your WP site fails to send an email or you are not able to get to your email address. In this situation, you need to reset your password directly in the database, and phpMyAdmin is one of the easiest ways to do that.
Now, let’s follow our guide to reset your WordPress password from phpMyAdmin in an easy way!
How to recover your WordPress password from phpMyAdmin
Step 1: Log in to the cPanel dashboard of your WP hosting account and then click on the phpMyAdmin icon below the database section.
Step 2: The phpMyAdmin app will open, and here you have to choose your WordPress database.
Step 3: Navigate to the ‘{table-prefix}_users’ table and click on the ‘Browse’ link next to it.
Note: Remember that the table names in the WP database may have a different table prefix from the one you see in our screenshot.
Step 4: There will be several rows in your WordPress users table. Click on the edit button next to the username whose password you want to reset.
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. Change the function to MD5 in the drop-down menu in the function column and click on the Go button.
If you have followed the 5 steps above, you have changed your WP password successfully. Your new password has been encrypted with the MD5 hash and stored in your WordPress database.
Why should you choose the MD5 hash to encrypt the password?
Some of you may be wondering why we chose the MD5 hash to encrypt the password.
In older WordPress versions, the MD5 hash was used to encrypt passwords. From WordPress version 2.5, it started using stronger encryption technologies, but WordPress still accepts MD5 for backward compatibility.
Therefore, if you log in with a password string that is stored as an MD5 hash, WordPress will recognize it and convert it using the newer encryption algorithms.
Conclusion:
That is all for today. We hope this guide helps you reset your WordPress password from phpMyAdmin.
While resetting your password, if you have any problems or questions, do not hesitate to leave a comment below or contact us through our Contact Page and submit Ticket Support. We will try to respond as soon as possible.
