How to change or recover Joomla Administrator password

Monday, 24 April 2006

TeachmeJoomla provides you this online recovery tool. This helps you set a new Joomla password for administrator by running SQL code on the database.

This is the Joomla administrator password recovery form.

This generates the sql code to overwrite your Joomla password with a new password typed in this form.

You need to run the generated sql code in PHPMyAdmin or your favorite MySQL interface.

We do not save or give away these passwords.This is Javascript code and it runs on your own machine.

Any questions are welcome at teachme [at] teachmejoomla[dot] com. Enjoy!

New password:

Database prefix (taken from $mosConfig_dbprefix in configuration. php).

Usual values are 'jos_' for Joomla and 'mos_' for Mambo respectively, whithout the quotes:

Click on the image to enlarge

Run sql using PHPMyAdmin
Run sql using PHPMyAdmin
 



Give us some social love (it really works now)!

Reddit! Del.icio.us! StumbleUpon! Yahoo! Swik!



Comments (81)
RSS comments
1. code03-03-2007 19:14

hi... well i guess it is a hard code... so i've been thinking if maybe one of you can send me the recovery password script (for password encrypting) to my email. 
 
I ill let it here; if anyone can send it i realy apreciate it. 
 
Thanks for your time !

2. forgot03-03-2007 19:23

Sorry... i forgot... my email is nightmare_9999@hotmail.com

3. thanks13-03-2007 18:48

so, thanks a lot tudor

4. GREAT GUYS I SOLVE THIS ISSUE!10-04-2007 18:32

Hi I just want to say thank you for this script, because I lose my Pass and I was scared already, not being able to get in to my administrator so, I used the form above and It worked out beautifully  
 
Thanks a lot! 
 
Alex

5. GREAT GUYS I SOLVE THIS ISSUE!13-06-2007 01:02

it did not work for me. 
i copied the generated code but i can't login.

6. It worked27-06-2007 08:49

Great tool! Thanks!

7. It worked07-07-2007 09:43

thanks a lot

8. Excelent10-07-2007 15:42

Thanks a lot!

9. Recovering password is not working for m13-07-2007 17:57

Do I need to change the jos_ users 
 
Or does admistrator go in the usernane or do I use the last one created

10. Vipyammer Streaming24-07-2007 16:41

Great...Just executed and working. 
 
Many Thanks...

11. Vipyammer Streaming25-07-2007 13:34
saved

superb, thanks!

12. OlderWiserWomen26-07-2007 06:59

Thank you! You saved my day!

13. Thank you!02-08-2007 06:34

lol, thank you! Well for beginners like me! It would of been nice to tell us where in phpmyadmin! 
I knew it was sql because of the image above. But i thoyght i had to click on jos_users or something! 
 
Here are step by step instructions. 
1. Make up a password!  
2. Use the password on this site to generate the code, now copy this code 
3. Go to ur hosting provider or cpanel, find ur mysql section.  
4. Then find one of ur databses, and click myphpadmin 
5. Right after u get into ur myphpadmin site click "SQL" 
6. Now paste ur code in main box u see 
7. highligh password on the right, and click go 
8. now go to ur web site,click administrator or ( www.yoursite.com/administrator/) 
9. Type in admin as USERNAME and for the PASSWORD type in the password u provided earlier  
10. press ENTER and u should be in!!

14. Thank you!03-08-2007 22:16

greatest help i have ever received....this script is awesome...keep it up

15. What can i do in case...14-08-2007 18:58

I have to insert that sql code everytime i want to log in my admin panel, theres a worm that got stucked in my site, it was phpbb forum or sth, ive already errased that fake module... by the way im using joomspanish 1.0.13... the SQL works, BUT... this worm keeps resetting my admin user and password, so that makes so annoying redoing all that sql code again! what can i do to change for good my password without having to apply that sql code everytime i have to log in? 
 
 
THANKS! waiting for your replies! 8)

16. Owner/Publisher16-08-2007 06:21

This is a great tool. For whatever reason my password was changed in dBase file. When I decrypted the MD5 encrypted password it came up as nothing.  
 
My only stumbling block was the fact I changed the title administrator name to something else but I kept changing it to the user id. Once I figured out that I needed to use the name I changed the administrator to everything worked fine. 
 
Please keep in mind I have NO SQL knowledge what so ever.  
 
Thanks, 
 
~Dale

17. Owner/Publisher06-09-2007 15:41
MGL

Thanks it works.

18. thanks a lot15-09-2007 03:18

It took me a little while before i got it that there are now super administrators. 
Then it just worked fine. 
Thanks a lot. 
Mark

19. DEAD SERIOUS IT'S WORKING19-09-2007 10:18

Guys,  
 
This thing working perfectly. no more problem with joomla admin password. Thank you Programming Dudes.

20. NEED MORE LIKE THIS20-09-2007 12:14

We hope new project from you guys

21. Try this before you give up21-09-2007 18:16

The password is stored in the MySQL database jos_users table password field 
I did this to chang my password 
1. login to control panel 
2. Find ( php my admin ) and click on it 
3. Look for the word ( Databases )click on it 
4. WARNING if you have more then one website on the server you must first fined the one  
the one you want to reset the password on. there ending with (_joomla )(if you need help ask) 
5.find ( jos_users ). To your right in the size section there will be a number with (KiB)ending in blue 
click on it  
6.Now on top look for ( Browse ) Click on it 
7.You can now see all the users and the user names. In the (usertype) finde (super administrator) 
go to its right and click on Edit  
8.copy and past this code over the old code in the password section 
21232f297a57a5a743894a0e4a801fc3 the code means ( admin )the new password  
9 I used the same name for both the username and name  
10. go to login and type the name you used and for the password type in ( admin )

22. Try this before you give up30-09-2007 03:40

Excellent - the other solutions were OK but this was the clearest and neatest. Well done!!

23. Thank you very much06-10-2007 04:18

:) Really very happy to use this tool. very simple and fast. 
 
Thanks a lot

24. Thanks09-10-2007 11:21

Thanks, your programme was of great help as one always forget to write down passwords! 
I am trying to generate passwords automatically for my users, but the generated codes do seem to be recognized when login in. Could you kindly send me the code behind the generation of your code? For your generated password functions correctly? 
Thanks in advance.

25. Thanks18-10-2007 07:46
Matthijs NL

THANX!!! It worked!!!

26. Thanks26-10-2007 03:45

great guys~this is an easy2use solution

27. That's a good script.29-10-2007 07:14

Thanks a lot, it works. Can you send me a copy of the script? Thanks again.

28. That's a good script.31-10-2007 12:03
nizar

Thanks

29. Great31-10-2007 18:01
Bert

This was a life saver. 
 
It works fine, though you may need to edit the SQL code manually. I had to edit the name of the table, nothing big. 
 
Thanks :)

30. Great12-11-2007 03:26
Krongchai

:) very good. Make me Happy.

31. Great13-11-2007 03:54
Cam

doesn't work 
 
not enough instructs for locating issue

32. Great02-12-2007 06:43

thanks to Wazrik. It worked a charm.

33. Great10-12-2007 22:26

can't thank you enough :)

34. Great18-12-2007 04:41
carl

Thanks Its cool............ :grin

35. Great24-12-2007 04:37

super!!! 
thanks a lot! saved my job!

36. Cool !!!09-01-2008 21:51

you are cool man ! really great help for all those in trouble ! :grin

37. Mr14-01-2008 09:21

Ive run the querie and now my whole site is down cant connect to the database.... 
 
 
 
HELP HELP :( :( :( :( :( :( :( :( :( :(

38. Awesome16-01-2008 19:39

Thanks for that! nice and easy, you people deserve a pat on the back!

39. Thx!18-01-2008 09:52

Oh thanks so much to YOU my friend. First time installing and everything worked except I couldn't log in! Followed those step by step instructions and VOILA. Code is brilliant. Thx!

40. Thx!18-01-2008 21:47

Can someone recover my password for me. I don't have the first inkling of what to do. I just know how to change things with the joomla program.

41. Vern Gosdin31-01-2008 06:54

I was lost but now I'm found...lol 
 
Tanks a million !!

42. Thank you!03-02-2008 11:56

Thank you so much. This helped me a great deal!

43. bugger me it works05-02-2008 07:55

Seriously reccommended if you ever get stuck ! it just works as per the instructions. Nick

44. bugger me it works05-02-2008 19:46

Worked perfectly. Thanks a million. This saved me.

45. bugger me it works07-02-2008 20:58
Boo

This fixed.... absolutely nothing! :(

46. login as admin08-02-2008 00:40

people trying to login are using the word Administrator as the user name. its not Administrator, its Admin.

47. login as admin10-02-2008 05:50

Thanks a lot for posting this. 
It worked like a charm. :)

48. tx10-02-2008 11:01
him

You saved my butt!

49. Thanks a lot!10-02-2008 20:49

Thanks a lot!

50. Thanks a lot!12-02-2008 08:46
jc

Thanks a lot for this, and thanks Wazrik for the idiots guide - I needed it!

51. Thanks a lot!15-02-2008 21:31
JustaThanx

Thanx worked great

52. Thanks a lot22-02-2008 10:34

Thanks worked great

53. Thanks a lot07-04-2008 04:42
mangoman

ohh yeahhh...very nice...thank you to the makers of this site...saved me from reinstalling joomla

54. http://www.datnet.org10-04-2008 09:58
Jon

Love your work! well done

55. http://www.datnet.org14-04-2008 05:20

Brilliant - Thank you so MUCH

56. super tool20-04-2008 21:42
peter

well done guys - really appreciate your knowledge 
 
peter

57. super tool26-04-2008 10:11

You F'ing rock! I've been locked out of my backend for god knows how long. 
Worked like a charm. Use your brains newbs. Joomla v. 1.5 
 
Thank you!

58. Locked out of backend10-05-2008 06:17

I've been locked out of my backend for over 3 weeks now i've tried everything i found, but still no joy...This is what happens i type in my user and password the screen blinks and im still on the login page no errors nothing i tried this it might work for others http://www.joomlaspan.com/Joomla-SMF-Bridge-Recover-Super-Administrator-Status-after-bad-synchronization.html but that didnt work for me, also tried module recover.php, if someone has an answer i done want to start all over again yes i did a DB backup before this error but the issue is still there.

This works perfectly, and can be used on any database using phpmyadmin not just Mambo and Joomla Cms.. :)

60. OOH Help me..16-05-2008 15:33

i updated the password fro phpmyadmin correctly but i can't login... 
What i have to put in the configuration.php in the var secret field?? 
Any Ideas??? 
 
thanks

61. OOH Help me..18-05-2008 20:02

thanks dude, you saved my life

62. GENERATED EMPTY PASSWORD!!! Please help!22-05-2008 15:28

I have used your recovery form to change the password, but i have made a big mistake...i have generated and excecuted sql string but i havent type ANY password... so now the password has changed but i have no idea what it is, i have tried empty, typeyournewpasswordhere but nothing roks. 
 
ANY IDEA?  
 
plase help

63. THIS IS THE SQL STRING I HAVE EXECUTED !22-05-2008 15:31

UPDATE jos_users SET password='3e7b906dadf044a086d4db2d48d12ba5' WHERE name='Administrator'; 
 
 
could i get my password from this?

64. thank you very much!26-05-2008 09:22

just tried it and it worked like a charm.. thank you

65. @Stas27-05-2008 00:28
Tudor

You need to write a password before generating the sql. You can do it now, it will override the blank password you have set by mistake

66. Thanks!02-06-2008 23:59

Worked like a charm.

67. Thanks!04-06-2008 12:08
lette

forgotten username and password

68. Thanks!08-06-2008 20:01

Hey! 
 
I tried above but thereafter I went to my website freshlightltd.com and it started to say This site is temporarily unavailable. 
 
It just happened right after I pushed the Go button in Sql! Does anyone a way to make this undone? 
 
Thank you so much in advance!:D 
 
Regards, 
Leon

69. THANK YOU09-06-2008 16:24

Seriously.. you're a life saver. Holy cow..  
 
I wish I knew how the password was changed between now and 6.5 hours ago, but this saved me.

70. THANK YOU14-06-2008 09:40

OK I've tried this several times but I am still getting Username and password do not match. 
 
The SQL command was processed correctly.

71. owner15-06-2008 23:11

i wana change joomla password

72. owner16-06-2008 18:30

After updating password, I still have password incorrect problem

73. Saved Me27-06-2008 05:57

Hello! 
 
I lost my password I know backup backup backup just when I was my vista barf crash However whas able to fixe it with this tutorial god bless. 
Pierre

74. Version 1.530-06-2008 18:55

Doesn't work with Joomla 1,5 , does it?

75. Excellent info01-07-2008 00:20

Thank you for the useful code. I was a able to change my password with no issues. Thanks again!!!

76. BIG THANK YOU it worked a gem12-07-2008 22:54

:grin  
 
Thank you to the origanl provider and to all those who have contributed!! 
 
You saved me many hours of redesigning..

77. testing16-07-2008 11:24

:eek :grin :p :? :( :x :upset :roll :p

78. testing19-07-2008 08:48

:grin :) This Really Works THNX very much u r great!!!

79. testing25-07-2008 12:35

WONDERFUL, WONDERFUL, WONDERFUL. I THOUGHT MY LIFE WAS OVER, BUT U SAVED IT. THANKKKKKKKKKKKSSSSSSSSSSSS

80. testing02-08-2008 11:29
Rick Diculous

:) Thank you so much for this site, saved my butt time and time again :D

81. testing06-08-2008 03:05
iain

:grin  
worked a treat!

Write Comment
  • Please keep the topic of messages relevant to the subject of the article.
  • Please don't use comments to plug your web site. Links are rel='nofollow'-ed
  • Please refresh the page if you're having trouble with the security image code
Name:
E-mail
Homepage
Title:
Comment:

:) :grin ;) 8) :p
:roll :eek :upset :zzz :sigh
:? :cry :( :x
Code:* Code

Last Updated ( Monday, 24 April 2006 )
 
468x60b

Newsletter

Subscribe to TeachMeJoomla's newsletter
Name:
Email:


Auto tags

joomla password

joomla admin password

joomla database password

change joomla password

joomla administrator password

reset Joomla password

joomla admin

lost joomla admin password

reset joomla admin password

password joomla

joomla lost admin password

joomla password recovery

recover joomla password

joomla reset admin password

joomla change admin password