How-To Guides and Blog

✔️ How to Reset WordPress Password from phpMyAdmin Database

NBH Support
NBH Support
No Comments

Imagine a scenario where you are locked out of your wp-admin dashboard, either by someone else or you just forgot your password. What can you do to get back into the admin area? Well the easiest way is to reset your admin password from your database via phpMyAdmin.

Reset WordPress Password from phpMyAdmin

The first step is to log into your cPanel and under Databases select phpMyAdmin.

Reset WordPress Password from Database, ✔️ How to Reset WordPress Password from phpMyAdmin Database, New Blog Hosting, New Blog Hosting

From the left side click on the database used by the WordPress installation that you want to reset the password for.

Reset WordPress Password from Database, ✔️ How to Reset WordPress Password from phpMyAdmin Database, New Blog Hosting, New Blog Hosting
TIP: If you have more than one database and don't know which is being used by your WordPress installation, simply open that installation's wp-config.php file and take a pick.

Once you are in the right database look for a wp_users table and then click on the Edit before your username.

Reset WordPress Password from Database, ✔️ How to Reset WordPress Password from phpMyAdmin Database, New Blog Hosting, New Blog Hosting

Under the user_pass row, for Function select MD5, and for Value put your new password.

Reset WordPress Password from Database, ✔️ How to Reset WordPress Password from phpMyAdmin Database, New Blog Hosting, New Blog Hosting

Click on the Go button at the bottom of the screen and thats it, you’ve just reset your WordPress admin password via phpMyAdmin and can now login to the admin area.

Leave a Comment