How to reset your WordPress password using phpMyAdmin

What to do when you’re locked out of your WordPress admin panel.

 Posted December 16, 2016

If you’re no longer able to access your WordPress admin panel because you’ve forgotten or lost your password, fear not; you can reset it by manually editing your SQL database with phpMyAdmin.

  1. Using phpMyAdmin, locate your WordPress database. If you’ve got many WP databases and are unable to figure out which one it is, look at the “wp-config.php” file in the root folder of your WordPress directory and find the line that looks like this: define(‘DB_NAME’, ‘xxxxx’);
    Your database name will be in place of the xxxxx.
  2. Open the database in phpMyAdmin and click on the wp_users table to see the list of WordPress users.
  3. Click on “Edit” on the line representing the user whose password you want to reset.
  4. Edit the user_pass value. IMPORTANT: You cannot type the password in plain text; you’ll need to generate your password using an MD5 hash generator. Go to one of the sites listed below, type in the password you want to use, generate the MD5 hash, and copy & paste that value it into the user_pass field in phpMyAdmin.
  5. Save, and you’re done!

MD5 Hash Generators:
Miracle Salad MD5 Hash Generator
Free Formatter
MD5Hasher.net

 

Leave a Reply

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