How to Recover and Change Lost WordPress Username and Password

If you have forgotten your wp-admin password, WordPress has built-in email recovery mechanism that you can use. How about if the email password recovery system doesn’t work? If that is the case, you can change lost WordPress username and password by accessing your database.


Username and Password Recovery Through the Database

One of the effective ways to recover access to wp-admin, is through the database PhpMyAdmin. This is applicable whether you have lost a username or a password.

How to do it?

1. Begin by logging into phpMyAdmin of your hosting and click the appropriate database. It’s name may depend on what you have assigned when you setup your hosting account.

2.  Find wp_users and click it.


3.  Find your Username under user_login. Click the name of the WordPress user whose login username and/or password you wish to change. In some versions of phpMyAdmin you need to click the pencil icon to edit it.


4. After you click the WordPress account you wish to edit, you will see fields for user_login and user_pass.


The image above shows wp_users data before editing. WP-admin username: admin is shown. WP-admin password on the other hand is MD5 system encrypted for security purposes. As such, you cannot see what its value. There is no way thus to decode its value. Thus, it is recommended that you change it.

6.  If password is what you wish to edit, you can need to change the value of user_pass. If it is WordPress login, then it should be user_login. You can also change both if you want but remember that these values are case-sensitive.  Also, Be sure to click the function drop-down for user_pass and select MD5.


The image above shows the user_login and user_pass before clicking “go”. Wp-admin username “admin” has been replaced by “sonny” and the unknown or forgotten wp-admin password indicated by user_pass is replaced by “sandwichx10.”  After we click “go” the user_pass will turn into encrypted code that you cannot anymore decode as shown by the succeeding image.


7. Go to your website login and test you new WordPress login and password.

I wish this simple tutorial helps you elevate your knowledge of WordPress a bit. If so, we wish to hear from you in the comment section. We also request you to share this post to your friends in the social media.

Leave a Reply

Your email address will not be published. Required fields are marked *