How to Reset WordPress Password with phpMyAdmin

Locked out of your WordPress site? Don’t worry—it’s a common issue and one that’s easy to fix. Whether you’ve forgotten your password or something went wrong during a recent update, this guide will walk you through the steps to reset your WordPress password using phpMyAdmin. No technical background is needed—we’ll keep things simple so that you can get back to your site quickly.

Reset WordPress Password

1. Log in to your Bluehost Account Manager.
2. In the left-hand menu, click Websites.
3. Click the MANAGE button located next to the website you want to manage.

   
    

4. In the website overview page, click the PHPMyAdmin button.

   
    

5. In phpMyAdmin, locate and click the + icon to expand your WordPress site's database in the left sidebar.
   To determine which database your WordPress site uses, check the wp-config.php file or refer to this article: How to Find Your WordPress Database.

   
    

6. Look for the table named _users and then click on it to view the user records.

   
    

7. Find the row with your admin username, then click Edit (usually a pencil icon) next to that row.

   
    

8. Locate the user_pass field.
9. In the Function column next to it, select MD5.
10. In the Value column, enter your new password (plain text).

    
     

11. Scroll down and click Go to save the changes.
12. Go to your WordPress login page. Use your username and the new password you just set.

Summary

And that’s it! You’ve successfully reset your WordPress password using phpMyAdmin. Just remember to always back up your database before making changes, and keep your login credentials secure. If you encounter any issues or require additional assistance, numerous resources are available within the WordPress community. Now go ahead and log back in—your site is waiting!