How to Reset WordPress Password from phpMyAdmin

So you forgot your WordPress password, right? But you also don’t have the access to your email address registered with the WordPress account. If you have access to the phpMyAdmin tool that comes with most of the managed web hosting providers such as Siteground or Bluehost, you can easily reset the WordPress password. In this article, we are going to list the complete list of steps that you have to follow to gain access to the WordPress backend by resetting your WordPress profile password using phpMyAdmin.

Reset Password in WordPress using phpMyAdmin

Most of the WordPress managed web hosting providers comes with cPanel or similar dashboard where you can find phpMyAdmin tool.

1. Open phpMyAdmin.
   
2. Click on the database table on the left side.
   
3. Now click on wp_users table on the right side.
4. Click Edit besides the user you want to reset the password of.
   
5. Enter your new password in the user_pass field.
   
6. Chooe MD5 in dropdown menu.
7. Click Go.

You will get a success message in green color and the password of the user has been successfully edited using phpMyAdmin. Be sure to note down the password somewhere or use a password manager to avoid repeating this over again.

Is it safe to use phpMyAdmin to reset password?

It is safe as long as you do not make any other changes to the database tables. Be extremely careful while playing with the database and edit the correct sections as mentioned in the steps. If you do anything wrong, your site or functionalities may broke. If you are not sure, you can take a database backup from your host before attempting to change password by editing it. phpMyadmin is like a database management tool that allows you to edit your database. That means, you do not necessarily need to use the tool to make changes if your host provides a separate tool that can edit the database tables.

Many hosting provides like Cloudways provide such database management utilities that can edit your database tables without phpMyAdmin. But I would recommend using phpMyAdmin for performing actions related to databases as it will be more stable than the newer tools developed by the hosts.