How to reset a WordPress password directly in the database (using PHPMyAdmin)?
METHOD 1
Go to
https://www.md5hashgenerator.com/
and calculate the MD5 hash for the password you want to use.
Open the WordPress users table (in PHPMyAdmin) wp-users and paste the MD5 hash into your user_pass field.
METHOD 2 (SNEAKY ONE!)
- Open the WordPress users table (in PHPMyAdmin) wp-users.
- Select a user with Administrator rights.
- Back up the (encrypted) password and email address of that user in a text file.
- Change the email address to your own email address.
- Go to the WP login page and click the ‘Lost your password?’ link.
- Enter your own email address (the one you entered in the database).
- Click the ‘reset password’ link in the email that you receive from WordPress.
- Enter a new password and you are in!
- Create a new user for yourself, with Administrator rights.
- In PHPMyAdmin, restore the password and email for the user you abused.
- DONE 😉
Resource:
http://www.wpbeginner.com/beginners-guide/how-to-reset-a-wordpress-password-from-phpmyadmin/