how to reset joomla password

May 25th, 2009 | Tags: ,
234x60

As a joomla developer of nepal , I have developed many websites in joomla! and its really very very hard to remember all the clients password, and sometimes its necessary to reset joomla password. Again just before some hours I reset password for nobel medical college website which is made in joomla. So here  I have described in very easy way to change joomla password from cpanel.  The below images shows the joomla login panel . Which we can generally access from

http://www.sitename.com/administrator

how to reset joomla password
how to reset joomla password

Lets describe how to reset joomla administrator password :
1. Now log in to cpanel of your website from http://sitename.com/cpanel
2. Now the cpanel of your website appears
3. Click on PhpMyAdmin as shown in the below image

How to reset your lost Super Administrator password in Joomla
How to reset your lost Super Administrator password in Joomla

4.Now you are in phpMyAdmin page of your cpanel
5. Click your database name from left panel , in the below image nobel_joom1 is my database name

 joomla password recovery
joomla password recovery

6. Now your are in your joomla database page, click on sql tab as shown in image.

How you reset an joomla administrator password?
How you reset an joomla administrator password?

7. now you will find a box “Run SQL query/queries on database ”
8.
Inside the box insert the following line which is underlined below
UPDATE `jos_users` SET `password` = MD5( ‘new_password‘ ) WHERE `jos_users`.`username` = “admin” ;

“new_password” – replace this with the new password you wish to use. Like I have used “anynewpassword”

“admin” – replace this if your admin username is different. (You can change password of any username. Like “admin”, “administrator”, “user” or any username)
9. Then click on go button on the below of box in right side.

Reset Joomla Password
Reset Joomla Password

10. Now go to the administrator panel of your joomla website http://sitename.com/administrator
11. Use the new password for the username that you have changed password.

reset joomla password
reset joomla password

12. welcome to the joomla administration. Enjoy .

How to reset the Joomla administrator password
How to reset the Joomla administrator password

Note : If this post has helped you to reset joomla admin password then please do not forget to leave your suggestions,comments or request any new post about joomla .

If it wont work then u can email to pracasinfosys@gmail.com or info@pracasinfosys.com for further details, your queries will be solved upon request

  1. jacob nelson
    May 27th, 2009 at 11:01
    Reply | Quote | #1

    many many thanks , its very easy for beginners and advance level joomla user, i liked it , please post more about joomla ,

    jacob nelson

  2. Berend
    June 10th, 2009 at 15:30
    Reply | Quote | #2

    Thanks Pracas! You are a star! Keep up the good work – your password reset help was very useful

  3. June 21st, 2009 at 23:34
    Reply | Quote | #3

    Hi there. I have tried this solution mentioned for my website footprints filmworks and i seem to be getting it all wrong. Do you have another detailed explaination.

    Regards
    MD for Footprints Filmworks
    Omar Abdulla

  4. kims cage
    July 27th, 2009 at 10:14
    Reply | Quote | #4

    you have done very great job , i searched a google and found lots of results , your article is the best one that you have described it very easily, you are digged man,

  5. August 1st, 2009 at 18:40
    Reply | Quote | #5

    Thank you for knowlage

  6. August 3rd, 2009 at 21:01
    Reply | Quote | #6

    Thand you for information

  7. October 15th, 2009 at 10:09
    Reply | Quote | #7

    thank you all for u r visit and comments, i have another method to reset joomla password , if it dosent works with you then please feel free to inform me , i will make another new post to reset joomla password.

    thank you all

  8. January 12th, 2010 at 09:52
    Reply | Quote | #8

    I tried like a million times and can not get it to work?

  9. February 10th, 2010 at 08:57
    Reply | Quote | #9
TOP