Have you ever needed to reset your admin account password in WordPress?

wp_users table

wp_users table

Maybe you have one too many blogs, or one of your friends or clients locked themselves out of their WP blog and they need to have the password reset?  I myself, have had many instances where upgrading a wordpress site or moving from one domain or web host to another left my admin account not able to login.  In any event, no matter what the problem I’m going to show y ou how to reset the password on any account in a WordPress web site.  The process is very simple and painless, even if you’re non-technical you should be able to follow the images to do this.

To be able to get this done you need to have access to your web control panel for your hosting account and the ability to access the MySQL datbase tool “PhpMyAdmin”.  So login to your web control panel, and find the PhpMyAdmin link and click on it.  On the left hand side click on your wordpress database (or select it from a dropdown) and a list of tables should appear in the left sidebar.  Go all the way to the botom and click on the “wp_users” table.

In the screen that appears in the right frame it will default to “structure”.  You need to click on the tab to the left of that “browse”

phpmyadmin default table view

phpmyadmin default table view

Once you click on browse you’ll get a listing of the wordpress accounts for your blog.  Just click the pencil (edit) button beside the account you want to reset or change the password for:

Edit user account WordPress

Edit user account WordPress

Next the screen that comes up will show you the details of that account.  Notice in the image below that the password fields is scrambled characters:

Wordpress reset admin password

Wordpress reset admin password

All you have to do is clear out the scrambled characters in the user_pass field, and then click on the dropdown field to the left and select “MD5” for encryption.

How to reset wordpress password

How to reset wordpress password

Once you do this, just click “go” in the bottom right corner and voila!  You’ve updated the password manually for a WordPress account!   If you have multiple accounts to rest passwords for, go back and repeat the process.