ThemeLab's Blog

Stay up to date with our newest WordPress themes, WordPress plugins, WordPress tutorials, and other announcements.

Reset Your WordPress Password via phpMyAdmin

Last Updated on by

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.

  • http://hotwordpresstips.com mayooresan

    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.

  • Leland

    @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.

  • http://hackwordpress.com Kyle Eslick

    This is definitely a useful tip!

  • http://learnsimply.wordpress.com Must!

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

  • http://lanoruegadice.com mikida

    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!!!

  • Leland

    No problem. Glad you all found this tutorial useful.

  • richard

    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.

  • aasma

    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 !!!!

  • http://www.mascobz.com bilal

    Thanks you have saved by blog’s life! :)

  • Tracy

    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.