Many posts on the respective forums are related to the loss or non functioning admin passwords.
How do I recover my admin password? You cannot recover the existing password, but you can reset it to a new password. The passwords are stored using a one-way MD5 hash which prevents recovering the password. But you can reset the password by editing the password field in the database. Set the password to a known value and then you may log-in using that new password. The password is stored in the MySQL database (Joomla!) jos_users table password field or (Mambo) mos_users table password field.
(change this for your table prefix if different) Use a MySQL utility such as phpMyAdmin or MySQL Query Browser to edit this field. Open the table, find your admin username, and then select that row for editing. The password must be hashed, you cannot simply enter text into this field. Set the password to a known value - password = "this is the MD5 hashed password" ------------------------------------------------------ - admin = 21232f297a57a5a743894a0e4a801fc3 - secret = 5ebe2294ecd0e0f08eab7690d2a6ee69 - OU812 = 7441de5382cf4fecbaa9a8c538e76783 Paste the hashed password into the field, save the change, and log-in using the new password. Immediately change your password to something more secure! or . . . Set the password to your own value Now if that all does not work you need to verify the values in the MySQL-tables. You could check jos_users table (Joomla) or mos_users table for your admin account. If not there, or it is incorrect, you could remove it and run this SQL-query but first BACK-UP your database!:
INSERT INTO `jos_users` VALUES (62, 'Administrator', 'admin', 'your-email'at'email.com', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', '', ''); INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0); INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);
Copy and past this first into Notepad or equivalent txt-editor (no Word!) and than into the SQL-query-window of phpMyAdmin. This should work as well.
Online MD5 tools - here are a couple online tools to create MD5 hashed values: - JavaScript MD5 - http://pajhome.org.uk/crypt/md5/ - MD5er - http://www.md5er.com/
Use the tools to create your own strong hashed password. Paste the result into the password field, save, and log-in with your new password. Free MD5 utilities - for download - MD5 & Hashing Utilities - http://www.digital-detective.co.uk/freetools/md5.asp - SlavaSoft HashCalc - http://www.slavasoft.com/hashcalc/overview.htm Download and use to make your own hashed password.
|