Post
by defcon6 » Thu Sep 06, 2012 12:38 pm
sourabh1,
Are you sure that you just didn't make a typing mistake? Some ISP's let you make simple one click backups and change passwords from cpanel, maybe this is the case with you? if not try this.
Once I changed my email address and found that somehow it deleted my account, after a lot of searches I came up with the following.
Login to MyPhpAdmin and choose the database on the left side of the screen for your site, press the SQL button to run an SQL Querry on db (DataBase). With pasting in the following text, it made a new Super User Admin account.
***Code for Joomla 1.5 ONLY*** (Let me know if you are using another Joomla version)
Firstly make a backup of your db.
INSERT INTO `jos_users`
(`id`, `name`, `username`, `password`, `usertype`, `gid`, `params`)
VALUES (LAST_INSERT_ID(), 'Administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
'Super Administrator', 25, '');
INSERT INTO `jos_core_acl_aro`
VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator2', 0);
INSERT INTO `jos_core_acl_groups_aro_map`
VALUES (25, '', LAST_INSERT_ID());
IMPORTANT: The first thing you now need to do is change the password.
Stephen