Reset WP Password Manually

Ever wanted to reset your password in WordPress, but for some reason or other you can’t use the reset password section? 2.5.1 has a bug where the reset password page doesn’t work, so this might be handy for you.

The phpMyAdmin way

Browse into the wp_users table in your database. Find your username and click on the edit icon () next to your username.

On the edit page, select MD5 from the Function dropdown next to the user_pass row. Change the value on the user_pass row to your new password and then hit Go.

Now log into WordPress with your new password and it will upgrade your password to the new phpass hashing.

The SQL query way

This applies where your database is wordpress and your login name is admin. Replace PASSWORD with whatever you want your new password to be.

UPDATE `wordpress`.`wp_users` SET `user_pass` = MD5('PASSWORD') WHERE `wp_users`.`user_login` =`admin` LIMIT 1;

After you login on your WordPress installation, it will upgrade your password to the new phpass hashing.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

17 Responses to “Reset WP Password Manually”

  1. Sara

    Thank you, thank you, THANK YOU! I just upgraded and when I went to log back in ran into this very problem!

  2. Weblog Tools Collection » Blog Archive » Reset WP Password Manually

  3. Wp Wordpress » Blog Archive » Reset WP Password Manually

  4. Reset WP Password Manually | BlogBroker24-7

  5. Reset Password Bug: Patch and Fixed Files — Ryan McCue’s Blog

  6. Matthew Helmke (dot) Net » I upgraded to WordPress 2.5.1 yesterday…and a bug was found today

  7. Primer Bug en WordPress 2.5.1 - Carrero Bitácora de los Hermanos Carrero, David Carrero Fernández-Baillo y Jaime Carrero Fernández-Baillo.

  8. Bug serio en Wordpress 2.5.1 | aNieto2K

  9. Peder Borg Borup / Reset dit kendeord/password manuelt i Wordpress via phpMyAdmin

  10. Problème avec Wordpress 2.5.1 | Flux de la passion

  11. » Bug en WordPress 2.5.1 Chesco Romero: Actualidad informática, Comunicaciones y Redes

  12. iTechnologize » WordPress 2.5.1 update, except fixes has issues too

  13. 512 Links: Dejen de lloriquear niñitas

  14. WordPress 2.5.1 + more fixes [builder2]

  15. Bug encontrado en WordPress 2.5.1 | Goldscripts

  16. Brian

    You’re a lifesaver!

    One thing - I think you might want ‘admin’ instead of `admin` (or so I found…) - otherwise, thank you!

    Brian

  17. Kike Gavilan

    ¿Y no era mas fácil generar el password y reemplazar el de la tabla?

    Un saludo.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Hi. I live here to keep the peace. You can ignore me now :)