How to Reset a WordPress Password from phpMyAdmin

How to Reset a WordPress Password from phpMyAdmin

Would you like to reset the WordPress password using phpMyAdmin?

If you cannot recover your lost WordPress password, you can reset it directly in your WordPress database using phpMyAdmin.

Here, we will share how to easily reset a WordPress password from phpMyAdmin.

Why Reset WordPress Password from phpMyAdmin?

WordPress allows you to recover a lost password easily. You can visit your WordPress login screen and click on the ‘Lost your password?’ link provided there.

Click the link to reach the password reset page. 

When you place your username or email address, WordPress sends a password reset link to the linked email address.

If you want to recover a lost password step by step, you can see our tutorial on recovering a lost password in WordPress.

But, if you can’t access that email address or your site fails to send an email, then you can’t reset your password.

In that case, you have to reset your password directly from phpMyAdmin.

Method to Reset WordPress Password From PhpMyAdmin

To set your WordPress password from phpMyAdmin, log in to the cPanel dashboard of your WordPress hosting account. Then, visit the Databases section, look for the phpMyAdmin icon, and click on it.

After clicking the phpMyAdmin icon, it will launch the phpMyAdmin app, where you have to select your WordPress database.

You will notice a list of tables in your WordPress database. You have to search for the wp_users table in that list and click the Browse link beside it. 

Note: Your WordPress database table names may differ from those in our image.

Now, You will notice the rows in your WordPress users table. Click on the edit tab next to the username whose password you want to change.

After that, PhpMyAdmin will display a form with all the user details fields.

You will have to delete the value in the user_pass field and enter your new password. In the function column, select MD5 from the drop-down menu and then click the Go tab at the bottom of the form.

Now, it will encrypt Your password using the MD5 hash, and then it will store it in the database.

Now, You have changed your WordPress password using phpMyAdmin successfully.

We hope this tutorial helped you learn how to reset a WordPress password from phpMyAdmin.

Leave a Comment