X

Reset Your WordPress Password via phpMyAdmin

WordPress Incorrect Password

It seems since the release of WordPress 2.5.1 – WordPress users have been experiencing issues with the built in password reset function.

Basically, the reset password function doesn’t work because the e-mail that’s supposed to contain the reset link never comes.

Not to worry, there is still hope if you have forgotten or lost your password. You can reset it via phpMyAdmin, a MySQL database administration tool.

Open phpMyAdmin

In your hosting control panel software, such as cPanel – there should be a link to access your phpMyAdmin. Usually this link is bundled close together with other MySQL database management tools. Here’s a screenshot of what it looks like in cPanel.

phpMyAdmin cPanel

Locate the users table

This is almost always called wp_users, unless you changed your database prefix.

WordPress User Database

After selecting the users table, you’ll need to click the Browse tab at the top, then click the little pencil icon next to the password you wish to change.

Change your password

You should now be on a screen like this.

WordPress Change Password

In here, type in the new password of your choice in the appropriate input field. Make sure you select MD5 from the dropdown menu. Click “go” and your new MD5’d password should be saved.

Login to your account

You should now be able to login to your account with the password you chose. WordPress 2.5.1 will automatically upgrade your password to the new encryption when you do this.

Conclusion

WordPress 2.5.2 is right around the corner, and hopefully this password problem will be corrected in that release. Make sure to always keep your passwords safe and to yourself. I hope you found this tutorial useful if you have been locked out of your WordPress 2.5 blogs. Thanks for reading and don’t forget to subscribe to the feed.

Comments  Leave a Reply

  1. Thanx for this article, my daughter and I have spent the last month trying to get her back into her blog because she had deleted the gmail address that she used and couldn’t remember the password, and this easy step by step way worked in less than 5 minutes.

  2. Thanks you have saved by blog’s life! 🙂

  3. thanking you very much
    the email reset is very slow by wordpress
    i got my password reset page in my mail account after 7 days, lol
    i deleted my 1 wp website cuz i didnt know any other way for resetting password..

    this method is great !!!!

  4. Hi,

    This is very valuable info. Thanks.

    Richard

    p.s.

    How can I change or move the WP folder. Now my url/domain is using WP or WP was installed at root dir. now I want it move to other folder so I can install other script to my root as my index. How do I move or change WP folder.

    thanks Again.

  5. No problem. Glad you all found this tutorial useful.

  6. Wow,

    yesterday I went to bed broken down, after having fought hours to get logged in in my new WP blog… And today this is the first chip of information that I find!

    Great! Thanks!!!

  7. Ups, it’s not too late for reading this post, even because of it, I ever reinstall my new blog. Nice guys.

  8. This is definitely a useful tip!

  9. @mayooresan: That is very true. It’s always a good idea to take backups, especially when messing with the database. Glad you liked the article.

  10. Day by day your articles are getting better and better… I have become a fan of your site!

    It’s a good idea to edit database, but we also should know that, if we crashed the database then whole blog is gone.. so whenever you do some edits in database make sure you make a back-up of your database. Incase anything go wrong you can restore your database.

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

WordPress Launch Checklist

The Ultimate WordPress Launch Checklist

We've compiled all the essential checklist items for your next WordPress website launch into one handy ebook.
Yes, Send Me the Free eBook!