Change / Reset WordPress password using MySQL / PHPMyAdmin

Imagine someone somehow manages to break into your WordPress dashboard, and changes it’s password and email. If you request a “Forget Password”, the reset password link will be mailed to the new email, not to your email. The result will be – you losing control over your WordPress-powered site. I think that’s enough to picturize that traumatic situation.

How would you cope up with such a problem? The first recommended step for a beginner-level user to restore WordPress is to contact the Hosting service. The restoration may take sometime, some hours, a day or even more depending on your Hosting provider’s service.

If you can dare to work in the cPanel or the control panel that your service has provided you with; here is a rather quick way to restore your password a few minutes.

Change / Reset WordPress password from MySQL / PHPMyAdmin

In the rest of this article, we’ll see how to reset WordPress password from PHPMyAdmin or MySQL.

Note: Implement only one of the below given methods, either Method#1 or Method#2 since both of these methods are similar and yield the same results. Following one of these two methods will help you to quickly regain control over your hacked WordPress admin account.

Method#1 – The Long way through PHPMyAdmin table editing

This method involves editing and updating the wp_users table values to reset our lost WordPress password. The method is little longer but is also easy enough to follow without knowing technical things.

1. Head over to PHPMyAdmin using your cPanel (or the hosting panel that your hosting service supports).
2. Click on your WordPress database.
   

   
   

3. Navigate to and click the table wp_users.
   

   
   

4. Edit the row with your WordPress username.
   

   
   

5. Now, in the user_pass field, change the function to MD5 and enter your new password in the Value section (refer below screenshot).
   

   
   

6. Click “Go” or similar option at the bottom to update the table values.
   

   
   

Method#2 – The Short way through MySQL

This methods implements the direct SQL query execution to update the wp_users table value to reset our hacked WordPress password.

1. Follow the first 3 steps of the above method.
2. Go to SQL or MySQL section in your PHPMyAdmin.
   

   
   

3. Now, enter the below given query:

   UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';

   Put your new password in place of yourpassword and replace yourusername with your WordPress username.

   
   

4. Click “Go” or similar option at the bottom to execute the query.

Congrats! You’ve successfully changed your WordPress password and regained the control over your WordPress admin, without even contacting your hosting provider. I found Method#2 very quick to implement, what about you?