Home / Joomla Tips & Tricks / How to Reset a Lost SuperAdmin Password 
Joomla Tips & Tricks
Jul
26
2006
How to Reset a Lost SuperAdmin Password
Written by Steve Burge   
Avatar

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 ;

Versions from Joomla 1.0.13 to 1.0.15

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 and you can encrypt your password using MD5 - the same system Joomla uses.

 

Comments  

 
#1 ton 2007-01-09 08:08
thank joe thank joe
Quote
 
 
#2 leon tb 2007-02-26 18:01
Thanxxxxxxxxxxx xxxxx very much!
Quote
 
 
#3 n0ta 2007-04-17 17:11
Great man!

I
Quote
 
 
#4 dave 2007-05-20 08:32
This is great! Thank a lot.
Quote
 
 
#5 eric 2007-08-11 15:33
UPDATE `DBSE NAME HERE`.`jos_users` SET `password` = md5('PASSWORD HERE') WHERE `jos_users`.`id` =62 LIMIT 1 ;
Quote
 
 
#6 Klaus Nitsche 2007-08-24 08:33
... 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 Superadministra tor's account and password to 'admin' now you need to use this query:

UPDATE `jos_users` SET `name` = 'admin', `password` = 'af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtR TddG' WHERE `id` =62 LIMIT 1 ;
Quote
 
 
#7 Steve Burge 2007-08-24 08:37
Thanks Zorro! :-) I'll change the post to reflect this.
Quote
 
 
#8 Happy user 2007-09-05 10:49
Thanks thanks thanks thanks !
Quote
 
 
#9 Les 2007-11-02 06:55
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

blog.mcdermotts.org.uk/2007/10/tutorial-recover-lost-password-in-joomla/

Great site by the way !
Quote
 
 
#10 Steve Burge 2007-11-02 07:29
Thanks Les

What version of Joomla are you running?
Quote
 

Add comment


Security code
Refresh