Resetting WordPress password via MySQL


So if you are reading this i am sure it is because you too have had an issue with not being able to access your wordpress admin area on a local dev machine.  This could be due to forgetting your WordPress admin password or because the password has become corrupted.

When this occurs it does mean you are unable to use the standard reset password email.  The good news is this very simple to fix as long as you have access to the database either directly or through a service such as phpmyadmin.

A standard WordPress install uses the wp_users table to store information about users and applies an MD5 encryption to the password field. If you run the query on your wordpress database such as :

UPDATE `wp_users` SET `user_pass`= MD5(‘newpassword’) WHERE `user_login`=’yourusername’;

This will then update your userlogin with your new password (in the example above it would set it to “newpassword”). We hope this helps sort your forgotten WordPress admin login password issue!



Leave a Reply