Welcome to Alledia, the #1 Joomla Training Company

Would you like to learn Joomla? We're here to help you:

Professionally-produced training videos and tutorials.
Guaranteed same-day answers to all your Joomla questions.
No Joomla experience needed. We've taught 1000s of Joomla students.

Home / Joomla Tips & Tricks / How to Reset a Lost SuperAdmin Password

Jul

2006

How to Reset a Lost SuperAdmin Password

Written by Steve Burge

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.

Set as favorite

Free Weekly Joomla Tutorials

Your Comments (23)

ton

January 09, 2007

thank joe thank joe

leon tb

February 26, 2007

Thanxxxxxxxxxxxxxxxx very much!

n0ta

April 17, 2007

Great man!

Im gonna put a statue if you in my room and kiss it everynight xD

Thanx man

dave

May 20, 2007

This is great! Thank a lot.

eric

August 11, 2007

UPDATE `DBSE NAME HERE`.`jos_users` SET `password` = md5('PASSWORD HERE') WHERE `jos_users`.`id` =62 LIMIT 1 ;

Klaus Nitsche

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 ;

Steve Burge

August 24, 2007

Thanks Zorro! I'll change the post to reflect this.

Happy user

September 05, 2007

Thanks thanks thanks thanks !

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 !

Steve Burge

November 02, 2007

Thanks Les

What version of Joomla are you running?

Les

November 02, 2007

Hi Steve

Running 1.0.13 cant remember what version of Mysql 4 i think

Cheers again

Les

Tanders

November 05, 2007

Tahx, You save my life!

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

K. Michael VerKamp

March 25, 2008

Thank you so much... worked for me smilies/grin.gif

Johnson

April 16, 2008

What Eric and Les said should work regardless of what version of Joomla you are using. I used Les's link. Worked great.

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

Paul B

May 29, 2008

anyone.. have a working version for 1.5??

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.

TheBeam

November 20, 2008

Where does one enter this information in? Is there more details on how to do this?

Please help.

DJ Ivan

January 23, 2009

Thanks , i had same problem i fix it i have joomla 1,0,14 , in your advise :D

Vergil Penkov

May 29, 2009

For 1.5, replace the whole field including the salt.
It's gonna work.

Omar Abdulla

June 19, 2009

Hi there. i am having a problem with my footprints filmworks admin manager. how do i reset my password and username.
please help

regards
omar abdulla