Have you ever needed to reset your admin account password in WordPress?
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
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
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
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
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.
As you mention, I can easily see myself needing to reset my WordPress password.
Where and how to find my password in the database, is information that I will keep handy.
Thanks. I really appreciate your emails and website as resources for my budding Internet Marketing career.
Great WordPress tip!
.-= Todd Casey´s last blog ..How to Reset or Change Admin or Any WordPress Password | JTPRATT’s Blogging Mistakes =-.
Wow ! what is great concept, you always provide some different and unique knowledge to followers. Doing well to share it.
When you set up WordPress for the first time a random password is generated then sent to my email. I would like to know if I can set up wordpress so that it changes and send me a new password each time I log in.
.-= web site marketing´s last blog ..Efficient web design and marketing solutions =-.
There isn’t something that will do exactly what you want, but maybe you would be interested in the One Time Password plugin.
excellent advice, i do not know we can enter the plain text and it will convert to MD5. Nioe finidings.
Thank you
.-= CascadingDropDown´s last blog ..VB code to Export Text to Excel and Save =-.
Thanks for the post. Very nice and instructive. It helped me a lot to change my password in my new wordpress blog that I recently started. I was so confused and at a loss earlier. But now I am comfortable with wordpress. It seems very easy.
Thanks for this step by step guide. I’ve always wanted to change my username, thanks for this.