How to create super admin login in joomla?

[sourabh1]

hello friends...
i have a super admin login account, but when i goes to login it says

"You do not have access to the administrator section of this site."

what should i do to recover it please help me

sourabh

[imanickam]

Review of the document http://docs.joomla.org/How_you_reset_an ... assword%3F could be of help.

Before attempting this, make sure to take a copy of the database content by exporting the content using tools/utilities such as phpMyAdmin.

[defcon6]

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