How To Reset A WordPress Password From phpMyAdmin
Last modified: September 25, 2020
If you need to reset your WordPress password, but are struggling with the general email reminder to reset, then you can bypass this and use the phpMyAdmin strategy instead. Follow these steps to help.
Step 1 – Backup
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.
Step 2 – cPanel
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.
Step 3 – Edit User Details
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.
Final Word: How To Reset A WordPress Password From phpMyAdmin
This is how to reset your WordPress password from phpMyAdmin and should only really be used if you’re locked out of the WP admin area. If you’re not locked out and you can access the area, you can achieve the same thing through the user list on the dashboard.
In addition, should you need to change the password because another user needs to change their password, you should also do this from the user list on the dashboard. Only ever use the phpMyAdmin scenario if you really need to.
A Savvy WordPress developer, years of experience developing for web (PHP, JS, jQuery, Vue, MySQL, etc.), SEO specialist, and more…