Ever lose or forget your user password for a WordPress website….now you can not log in and make updates. This can be a big problem. There is a pretty easy fix…if you have access to the backend through cPanel. Here are some step by step instructions that hopefully work for you (they did for me):

First you need to login to the cPanel dashboard of your WordPress hosting account. Next, you need to click on the phpMyAdmin icon under the database section.

This will launch the phpMyAdmin app where you need to select your WordPress database.

You will now see the list of tables in your WordPress database. Now you need to look for the ‘{table-prefix}_users’ table in this list and click on the ‘Browse’ link next to it.

You will now see the rows in your WordPress users table. Go ahead and click on the edit button next to the username where you want to change the password.

PhpMyAdmin will show you a form with all the user information fields.

You will need to delete the value in the user_pass field and replace it with your new password. Under the function column, select MD5 from the drop down menu and click on the Go button.

Your password will be encrypted using the MD5 hash and then it will be stored in the database.

Congratulations! You have successfully changed your WordPress password using phpMyAdmin and should now be able to log into your WordPress Website.

Here is a full listing of step by step directions and screenshots from WP Beginner in case you need them:  https://www.wpbeginner.com/beginners-guide/how-to-reset-a-wordpress-password-from-phpmyadmin/

Scott E

LEAVE A REPLY

Please enter your comment!
Please enter your name here