How To Reset A WordPress Password From phpMyAdmin

The first step should always to backup your MySQL database. If an error is caused by your work on this task, then it is helpful for you to have a backup to reset the website to how it was before. Keep the backup of your database in a secure place. Don’t try to make changes to the backup.

Now you need to login into the cPanel dashboard that is connected to your WordPress hosting account. Then you can click on the phpMyAdmin icon within the database section. This will launch the phpMyAfmin app and you can select the WordPress database from here. You will need to find the table that is listed as ‘[table-prefix]_users’. Click on the ‘Browse’ link that will be next to this.

You will now see rows in the user table. Search the list and click on the edit button next to your username. PhpMyAdmin will now show you all the data that is connected to that user.

Delete the information that is next to the field labeled user_pass and then replace it with a new password. Be sure that the password is at least 8 characters long and has an uppercase, lowercase, number and special character within it. You should also select the MD5 from the dropdown menu.

When you’ve completed this, click on the ‘Go’ button.

Now you’ve completed the process of changing your password. You might need to workout why your password was changed. Was it because you’ve forgotten it, or had your password been changed during a hacking incident? Be sure to have the best WordPress security plugin installed on your site to prevent your site from being hacked in the future.

You should also make sure that you know your password at all times. But never write down the password in an area where someone else could see the password.