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.
Marulz Blog » Blog Arşivi » Weblog Tools Collection: Reset WP Password Manually
Trackback at 2:36 am on May 14th, 2008手动重置 WordPress 密码 - WordPress中文站
Trackback at 10:19 am on May 15th, 2008I also needed to change `admin` to ‘admin’. Otherwise I get this error:
#1054 - Unknown column ‘admin’ in ‘where clause’
Thanks Ryan McCue and Sara!
B
手工重置wordpress2.5.1登录密码 | 畅想帮
Trackback at 12:36 am on June 3rd, 2008Ben and Brian: I’ve corrected this now, thanks.
Kike: Unfortunately, I don’t speak Spanish
Thank you so much! Worked like a charm!
I went ahead and changed my admin username to chris too, for added security!
Thank you! WordPress has been seriously NOT working for me on so many fronts since 2.5 rolled out.
Thanks it helped.
Thank you so very, very…v.e.r.y. much. I lost my cookies when I upgraded to Firefox 3 and was about to give up and do a fresh install/recreate my entire site there goes my day/::sigh:: when I found this. You made my day! >^_^<
Omigod! You’re a LIFE-SAVER!
Am linking my blog to yours so
others will also know!
THANK YOU and God bless!!
kelly
Singapore
MyQute Fairy-Angel Blog » I became a Twitter after Wordpress 2.5.1 upgrade
Trackback at 12:36 am on July 1st, 2008