Reset a WordPress Password from phpMyAdmin Database

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

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!