How to reset WordPress admin password from PhpMyAdmin

Sometimes you may forget your WordPress admin password. If you remember your username or email address for the admin account, you can use the built-in WordPress password reset tool to reset your WordPress password. However, if you don’t remember your WordPress username or email, what do you do in that case? Don’t despair. You can still reset your WordPress admin password. In this article, we will look at how to reset WordPress admin password from PhpMyAdmin

Step 1: Log in to your cPanel account

Login to your Cpanel account by visiting www.yourwebsite.com/cpanel enter your username, password, and click on login. Remember to use your domain name instead of yourwebsite.com

Step 2: Open PhpMyAdmin

Search for phpMyAdmin and click on it to open it.

Step 3: Navigate to the users table

Click on your WordPress database to open up the list of tables. Navigate to the users table, in this case it is the wp_users table. The prefix wp_ might be different for you.

Here you will find a list of usernames and their encrypted passwords. Click on edit for the user whose password you want to reset.

Step 4: Reset WordPress admin password from PhpMyAdmin

In the user_pass field, under function select MD5. Enter your new password in the value field.

Once you are done, click on Go

You will have now successfully reset your WordPress password.

Conclusion

Resetting your password through phpMyAdmin may seem like a daunting task at first. But as you might have realized after following our tutorial it’s a quick and easy solution in case you forget your username or email.