"How do you recover your admin password?" don't work

mejean · **Posted:** Wed Dec 10, 2008 1:10 pm

See on wiki http://docs.joomla.org/How_do_you_recover_your_admin_password%3F

It's don't work for me Good SQL request should be :

Code:

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`)
        VALUES (null, 'Administrator2', 'admin2', 'votre-email@domaine.com', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());

It's work for latest Joomla! 1.0 and 1.5

Or

Code:

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`)
        VALUES (null, 'Administrator2', 'admin2', 'votre-email@domaine.com', '296e21e19e0a53e6eacc64bc8cf6e134:w15sQL14fsn2V8MFpPmWZTz9LVgmZIaj', 'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());

for Joomla! 1.5 (not tested on Joomla! 1.0)

Thank to Ouly.

dextercowley · **Posted:** Wed Dec 10, 2008 4:04 pm

Hi Jerome. Thanks for the suggestion. I'm testing them out. What are the matching passwords in your examples above? Thanks. Mark

mejean · **Posted:** Wed Dec 10, 2008 4:45 pm

Passwords is admin for each of this examples.

In the first case it's seem to be the old encryption before the 1.0.13, but works in a 1.0.15

If you create an new administrator with the password admin in the Joomla! console, result will not be 296e21e19e0a53e6eacc64bc8cf6e134:w15sQL14fsn2V8MFpPmWZTz9LVgmZIaj

I don't now exactly how Joomla! encrypt password.

dextercowley · **Posted:** Wed Dec 10, 2008 6:29 pm

Hi Jerome. Thanks for the information. I've updated the Wiki article with the new query. Mark

Joomla! Discussion Forums

"How do you recover your admin password?" don't work

Quick reply

Who is online