You are here
Home > Latest News > Technology News > how to change wordpress password via phpmyadmin

how to change wordpress password via phpmyadmin

wordpress password

Change / Reset WordPress password using MySQL / PHPMyAdmin

Learn how to recover lost or hacked WordPress password from PHPMyAdmin / MySQL.

WordPress is not so safe in terms of its security and there are instances when hackers may steal or change your password. Just imagine someone somehow manages to break into your WordPress dashboard, and changes it’s password as well as the administrative email. In this situation recovering your password will be impossible as if you request a “Forget Password”, the reset password link will be mailed to the new email, not to your email. Hence, you will not be able to get hold of your account. This is where you need to access your database and modify your password through phpmyadmin / mysql. There are so many wordpress websites such as dissertation writing services which are vulnerable to hacking attacks and need tighten their security. 

How would you be able to handle this 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.
  1. 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?



Master Blog Writer
Master Blog Writer is the best platform for blog and article writers wishing to share the knowledge, ideas and information with like-minded people.

Leave a Reply