You can try this method too
<blockquote>Add a New Super Administrator UserIf changing the password won’t work, or you aren’t sure which user is a member of the Super Administrator group, you can use this method to create a new user.
- Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
- Press the “SQL” button in the toolbar to run an SQL query on the selected database. This will display a field called “Run SQL query/queries on database <your database>”.
- Delete any text in this field and copy and paste one of the following queries and press the Go button to execute the query and add the new Administrator user to the table.
NOTE: The following code uses jos_ as the table name prefix which is the Joomla default table prefix If you elected to change this prefix when you first installed Joomla, you will need to change jos_ to the prefix you used.
SQL code for use with Joomla 2.5.x 3.1.x
INSERT INTO `jos_users`
(`name`, `username`, `password`, `params`)
VALUES ('Administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');
At this point, you should be able to log into the back end of Joomla! with the username of “admin2” and password of “secret”. After logging in, go to the User Manager and change the password to a new secure value and add a valid e-mail address to the account. If there is a chance you have been “hacked”, be sure to check that all users are legitimate, especially any members of the Super Administrator group.</blockquote>
ekaup 11 years, 2 months ago.
