| How to Reset a Lost SuperAdmin Password |
|
| Wednesday, 26 July 2006 | |
|
If you do lose your SuperAdmin password for Joomla, don't worry because theres an easy way to get it back. Just login to your MySQL database and run this query for versions up to Joomla 1.0.12.
UPDATE `jos_users` SET `name` = 'admin', `password` = '21232f297a57a5a743894a0e4a801fc3' WHERE `id` =62 LIMIT 1 ;
For 1.0.13:
UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ;
Your username will now be admin and your password will be admin also.
If you're running an older version of Joomla or Mambo, you might need to change jos_users to mos_users.
If you'd like to change your password to something other than admin, go to http://www.allhype.co.uk/tools/md5/ and you can encrypt your password using MD5 - the same system Joomla uses.
Set as favorite Bookmark
Email This
Comments (18)
  written by n0ta, April 17, 2007
Great man!
I´m gonna put a statue if you in my room and kiss it everynight xD Thanx man written by eric, August 11, 2007
UPDATE `DBSE NAME HERE`.`jos_users` SET `password` = md5('PASSWORD HERE') WHERE `jos_users`.`id` =62 LIMIT 1 ;
 written by Zorro, August 24, 2007
... since that version changed password handling and added a SALT to the password field. The method described here used to work up to Joomla 1.0.12 but no more.
To reset the Superadministrator's account and password to 'admin' now you need to use this query: UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ; written by Les, November 02, 2007
Hi The script didnt work. I used the method found here and seems to work to get you back in if anyone else is struggling
http://blog.mcdermotts.org.uk/...in-joomla/ Great site by the way ! written by Les, November 02, 2007
Hi Steve
Running 1.0.13 cant remember what version of Mysql 4 i think Cheers again Les written by Jeremy, November 07, 2007
First of all I'd like to say thanks for putting this out there. Secondly, this doesn't seem to work for me. I've tried both commands posted above and both give me the result below. Even after restarting mysql I cannot log into my joomla with admin/admin. Any thoughts?
mysql> UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 written by Johnson, April 15, 2008
What Eric and Les said should work regardless of what version of Joomla you are using. I used Les's link. Worked great.
written by rita, May 03, 2008
Hi guys,
what about joomla1.5.1? I tryed with this: mysql> UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG' WHERE `id` =62 LIMIT 1 ; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 but it didn't work. If somebody can help... i would thank a lot written by Peter Nassoit, September 16, 2008
Here is a working version for Joomla 1.5.7:
UPDATE `jos_users` SET `name` = 'admin', `password` = 'e78320298d96b322d97aa60debde4659:kXRQ5gLWlOWgW2wbuKTC9 QpgaxfJ7vi8' WHERE `id` =62 LIMIT 1 ; note: this assumes that you are using the default "jos_" as the prefix for your database tables. Write comment
|
Show/Hide comments
I'll change the post to reflect this. 
Show/Hide comment form
