|
If you work with Joomla! enough to the point that you have a lot of sites, you will inevitably forget your Super Administrator password. I know I have done it. Do not fear, there is hope!
The best part is that this works for both Joomla! 1.0.x and Joomla! 1.5.x.
- Before into the all the technical mumbo jumbo, I should state that if there is another Super Administrator account on your website, it is very easy to ask that Super Administrator to log in and reset your password. If you do not have any other Super Administrator accounts on the website, then we need to get creative.
- Open phpMyAdmin. Typically, you can find this application host's Control Panel.
© The phpMyAdmin Project
- If you have multiple databases, select the database for the Joomla! instance that you are having problems logging into.
© The phpMyAdmin Project
- On the left side of the screen, find the "users" table. Typically, it is called "jos_users". When you find it, write it down or just make a mental note of it.
© The phpMyAdmin Project
- On the right side of the screen, click the "SQL" tab.
© The phpMyAdmin Project
- Now is where the fun begins. We need to build our SQL statement to update the table inside the "Run SQL query" text box.
If you are a novice at SQL, there are only three parts of the following SQL statement that you are allowed to edit. If you are comfortable with SQL, you can do whatever you want. The following SQL statement will work for most people. See comments below the SQL statement to make sure that you are not one of the ones that need to tweak it a little.
UPDATE jos_users SET password=MD5('thinkbigshot.com') WHERE username='admin';
- jos_users – remember in Step 3, we clicked on the "jos_users" table link on the left side? Well, if your table was named something different, like "jos2_users", you want to change the SQL statement to match.
- admin – if you are wanting to reset the password for another user besides "admin", then you will want to change it to the username you are resetting.
- thinkbigshot.com – Personally, I think "thinkbigshot.com" is a great password. However, not everyone will agree. Change this to whatever you want, however, you will want to stay away from using special characters, especially an apostrophe as them may have adverse results.
- Assuming that you did not change anything in the SQL statement, once you click "Go" you should now be able to log as "admin" using the password "thinkbigshot.com". Once you are able to log in, I suggest that you change the password to something more secure.
Now, I know some of you may be saying to yourself, "This guy just saved my life" or "How can I ever repay this guy?" Well, it's easy, just leave a comment saying "Thank You". Please do not send flowers.
Kenneth Crowder has been involved in the Joomla! Community since the
days of Mambo. He has volunteered many hours to help out the Open
Source Project. He is considered an expert in all things related to
Joomla!. He was a Technical Reviewer for Joomla! A Users Guide, as well as another book currently in the editing phase. Learn more about Ken.
Trackback(0)
 |
TrackBack URI for this entry
Subscribe to this comment's feed