Reset a WordPress Password from phpMyAdmin Database

by ONELIVE Webmaster

When to reset a password through the database

Use this technique if a site gets hacked or a user no longer has access to their emails.

Watch Video

https://youtu.be/4hGUso4Ktok

Instructions

  1. Open the site's phpMyAdmin.
  2. Find and browse the users table
  3. Search for the user you want to edit. You will see a table named 'userpass', this is the field that needs updated. NOTE: You cannot simply add the password to 'userpass' table b/c it is a MD5 hashed value. To get around this you need to convert your password to a MD5 Hash value.
  4. go to md5hashgenerator.com and paste your password into the field. Copy the value it returns and paste that in the user_pass table. Click save.
  5. Open up your wordpress site and use the new password. You should have access now!
Back to WordPress Site Development