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.
Comments (14)
Thank you, thank you, THANK YOU! I just upgraded and when I went to log back in ran into this very problem!
You’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.
I 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
Ben 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
thank you very much ! it’s useful!!
Thanks a lot! ^^
Bravo.
Thanks for this info man, really really need it.
After spending 4 1/2 hours of trying to log back in to WP, you solved my problem immediately. A MILLION thanks.
Trackbacks/Pingbacks (19)
[...] you are having issues with the reset link right now, you can read this post by Ryan McCue on how to Reset your WP Password Manually through phpMyAdmin. (No Ratings Yet) Loading … Sphere: Related Content [...]
[...] you are having issues with the reset link right now, you can read this post by Ryan McCue on how to Reset your WP Password Manually through [...]
[...] you are having issues with the reset link right now, you can read this post by Ryan McCue on how to Reset your WP Password Manually through phpMyAdmin. Share and Enjoy: These icons link to social bookmarking sites where readers [...]
[...] my last post on how to reset your WordPress password manually, people have asked for the patch and the changed files for the bug in 2.5.1. I’ve grabbed [...]
[...] your password, the login link you are sent doesn’t work and you end up locked out. You can reset a WP password manually, and here is a link to two updated files that fix this [...]
[...] siempre podemos resetear nuestra contraseña de forma manual si no [...]
[...] Siempre podemos acceder directamente a la base de datos para resetar la contraseña: [...]
[...] er åbenbart en bug i Wordpress 2.5.1. Heldigvis er der en her, der har lavet et blogindlæg som viser, hvordan du kan ændre dit password manuelt via [...]
[...] Lire l’article chez >Ryan McCue [...]
[...] mediante el acceso a las tablas de la base de datos del blog y se puede hacer, según leo en el blog de Ryan McCue’s de dos formas: vía phpMyAdmin y vía consulta SQL. De modo general y para que no hay algún listo [...]
[...] is pretty much explained by Ryan McCue a 14 year old WordPress user & developer, it’s a manual way of reseting the password through phpMyAdmin. Finally, all those who don’t have the opportunity to access phpMyAdmin [...]
[...] Resetear la contraseña de WordPress manualmente, para las chicas que soltaron en lágrimas al descubrirse el magno-agujero de seguridad de wordpress 2.5.1 que seguramente (valga la repetición) es tan grande que puede pasar un porta-aviones en él… obvio que es sarcasmo… [...]
[...] in the 2.5 series. But even just after 2.5.1, some problems were exposed, notably the one that requires you manually resetting your passwords because the password recovery links wouldn’t work as designed. The patched files can be [...]
[...] Tambi
[...] you are having issues with the reset link right now, you can read this post by Ryan McCue on how to Reset your WP Password Manually through [...]
[...] 这个 bug 将在 WordPress 2.5.2 中修复。然而，如果你现在就有这方面的麻烦，你可以阅读 Ryan McCue 的文章，通过phpMyAdmin“手动重置 WordPress密码”。此文为英文，感兴趣的网友可以翻译为中文。 [...]
[...] 事实上，手工重置wordpress登录密码并不是2.5.1版本的专利，只不过很多时候，通过email可以完成重置密码的过程。但是如果失败了，或者出于2.5.1特有的email重置密码bug，就需要参考Royan的这篇reset WP password manually了。下面的是部分译文：（我就直接本主题了，省略介绍部分） [...]
[...] this qooool tip from cubegames.net saved me! Whew! [...]
[...] via Ryan McCue [...]