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.
Thank you, thank you, THANK YOU! I just upgraded and when I went to log back in ran into this very problem!
Weblog Tools Collection » Blog Archive » Reset WP Password Manually
Trackback at 7:20 am on April 27th, 2008Wp Wordpress » Blog Archive » Reset WP Password Manually
Trackback at 8:25 am on April 27th, 2008Reset WP Password Manually | BlogBroker24-7
Trackback at 9:32 am on April 27th, 2008Reset Password Bug: Patch and Fixed Files — Ryan McCue’s Blog
Trackback at 3:54 pm on April 27th, 2008Matthew Helmke (dot) Net » I upgraded to WordPress 2.5.1 yesterday…and a bug was found today
Trackback at 6:59 am on April 28th, 2008Primer Bug en WordPress 2.5.1 - Carrero Bitácora de los Hermanos Carrero, David Carrero Fernández-Baillo y Jaime Carrero Fernández-Baillo.
Trackback at 4:09 pm on April 28th, 2008Bug serio en Wordpress 2.5.1 | aNieto2K
Trackback at 4:28 pm on April 28th, 2008Peder Borg Borup / Reset dit kendeord/password manuelt i Wordpress via phpMyAdmin
Trackback at 4:58 pm on April 28th, 2008Problème avec Wordpress 2.5.1 | Flux de la passion
Trackback at 2:28 am on April 29th, 2008» Bug en WordPress 2.5.1 Chesco Romero: Actualidad informática, Comunicaciones y Redes
Trackback at 9:36 pm on April 29th, 2008iTechnologize » WordPress 2.5.1 update, except fixes has issues too
Trackback at 6:24 am on April 30th, 2008512 Links: Dejen de lloriquear niñitas
Trackback at 2:06 pm on May 1st, 2008WordPress 2.5.1 + more fixes [builder2]
Trackback at 9:50 pm on May 1st, 2008Bug encontrado en WordPress 2.5.1 | Goldscripts
Trackback at 7:18 am on May 3rd, 2008You’re a lifesaver!
One thing - I think you might want ‘admin’ instead of `admin` (or so I found…) - otherwise, thank you!
Brian
¿Y no era mas fácil generar el password y reemplazar el de la tabla?
Un saludo.