This WordPress guide teaches you how to reset a WordPress password using PHPMyAdmin.
If you have lost or forgot your WordPress password, you can reset it easily by using the Forgot Password link on the Login screen. WordPress will then send a “password reset” link to your registered email id and by visiting that link, you can easily change your WordPress password.
For more details, see our tutorial on how to recover a lost password in WordPress.
However, what if someone hacked your WordPress account and changed its username, email, and password. How would you recover the password in that situation?
Sit Relax! There is always a way out.
WordPress users can reset their lost password via the PHPMyAdmin database. Follow the steps below.
Reset WordPress Password via PHPMyAdmin
- Login to your WordPress hosting Cpanel dashboard. Go to phpMyAdmin under the Database section.
- Click on your WordPress database on the left side.
Note: If you don’t know your database name, look for the database_name in the wp-config.php file.
define(‘DB_NAME’, ‘database_name’); // where database_name – name of the database
- Now, you’ll see the list of tables. Find and click the table “wp-users” from the list. Note: table name could be different in your database. For me, it is wp0l-users.
- You’ll see your WordPress username tables. Click on Edit to change its information.
- Under user_pass column, change the function to MD5 and enter the new password inside the value section. Remember to use a case-sensitive password.
- Click on the Go button at the bottom to save the changes.
That’s it! You have successfully changed your WordPress password using phpMyAdmin.
Additionally, if you want to change the username, enter the new user value under the user_nicename field.
Important: It is recommended to use the MD5 hash as WordPress uses this technology to encrypt passwords.
Now, login to your wp-admin dashboard using the newly created password.
Frequently Asked Questions:
Q: How do I change my WordPress Password?
A: To change your WordPress password, log in to the wp-admin dashboard. Go to Users > All users. Click on your username, scroll down and click Generate Password. Here, change your password and click Update.
Q: How do I reset the password if WordPress is unable to send password email link?
A: In such case, you need to change your password using phpMyAdmin. This tutorial is created for that purpose.
Q: How do I access my WordPress database?
A: In order to phpMyAdmin database, go to your hosting Cpanel dashboard. Here, locate Database > phpMyAdmin. Open it and you’ll see the list of database and by clicking on it will open list of database tables.
If you liked this article, please share this article using the below social icon. If you want to learn more how-to guides on WordPress, visit our WordPress category section.
Please follow us on Facebook, Twitter, and Google+. You can also subscribe to our Youtube channel for how-to stuff Videos.