Here are a couple of options to try:
1. Promote User to Superuser
Check that the user account you are logging in with is a member of the Super Users group.
Log in to cPanel and go to phpMyAdmin (or similar) and ensure that the group_id
of the relevant user in the [your_prefix]_user_usergroup_map table is set to the Super Users Group ID which by default is 8
.
You should now be able to log in with full privileges.
2. Add a New Super Administrator User
Assuming you have access to cPanel and phpMyAdmin (or similar), you can create a new Superuser in Joomla 2.5 and Joomla 3.x as per Add a New Super Administrator User in the official documentation:
- 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 ".
- Delete any text in this field and copy and paste the following query below and press the Go button to execute the query and add the new Administrator user to the table.
- Use the SQL query below to add another administrator account.
Make sure you match your db table prefix!
The following code uses jos31_ as the table name prefix which is only an example table prefix. The prefix when you first installed Joomla is RANDOM or what you set it specifically too. You will need to change all occurrences of jos31_(your install set prefix) found in the code below to the prefix your installation is using.
INSERT INTO `jos31_users` (`name`, `username`, `password`, `params`) VALUES ('Administrator2', 'admin2', 'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `jos31_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.