Trendy:

SMS Solution Center

Blog

  • Written by Administrator

Joomla 2.5 – User Lost Super Administrator Access

Joomla 2.5 Tutorials – Not too sure how it happened, but one of my super admin user lost Super Administrator access.  I might have accidentally changed it in the backend now I do not have access to the backend with Super Administrator access.

How to fix?  Below I will show you how to do it.  You will need access to your database via the phpMyAdmin through your web hosting provider.  Only make these changes below if you know what you are doing.  Making a mistake will bring down your website.

Overview of How to Grant Super Admin User Super Administrator Access

  • Get the Super Admin User ID in the _users table
  • Get the Super Users Group ID in the _usergroups table
  • Find & Edit the User in the _user_usergroups_map table
  • Change Group ID in the _user_usergroups_map table

Steps:

1.  Get the Super Admin User ID in the _users table

After logging into your database and access your Joomla 2.5 website database.  Along the left navigation you will find all the tables in your database.  Each user you create in Joomla 2.5 is associated with a User ID.  Each User ID is unique.   You will need to associate this User ID with a Group ID  later in Step 4.

cmsmind joomla 2 5 change to super administrator Joomla 2.5   User Lost Super Administrator Access

Joomla 2.5 – _users table see Super User User ID

  • Search for the table name _users
  • Click on table name _users, click on ‘Browse
  • View your table contents and see in my case my Super User ID = 42
  • That is the User ID I want to have Super Administrator access.

2.  Get the Super Users Group ID in the _usergroups table

Now there is a group ID for the Super Administrators (Super Users).  You will need to find this Group ID number to associate it with the User ID in step 1.

cmsmind joomla 2 5 change to super administrator 2 Joomla 2.5   User Lost Super Administrator Access Joomla 2.5 – Super Administrator Group ID _usergroups table

  • Search for the table name  _usergroups
  • Click on the table name _usergroups and click on the ‘Browse‘ tab
  • View the contents and see that the ‘Super Users’ Group ID = 8

3.  Find & Edit the User in the _user_usergroups_ map table

Now we want to match the User ID with the Group ID in the _user_usergroups_map table.  This table is how Joomla 2.5 manages user groups.  It maps the User ID in step 1 with the Group ID in Step 2.

cmsmind joomla 2 5 change to super administrator 3 Joomla 2.5   User Lost Super Administrator Access

Joomla 2.5 – User groups Map table

  • Search for the table name _user_usergroups_map
  • Click on the table name _user_usergroups_map and click on the ‘Browse‘ tab
  • You can see in the above screenshot that my User ID 42 is incorrectly mapped to Group ID 2.  If you look at Step 2, Group ID 2 is an Registered group.
  • So I need to edit User ID 42 to be Group ID = 8
  • for User_ID = 42, Click  on the ‘Pencil‘ icon (second column) to edit the row

4.  Change Group ID in the _user_usergroups_map table

As mentioned above, we are going to edit the Super User to have Super Administrator rights by editing the User ID in the table _user_usergroups_map.

cmsmind joomla 2 5 change to super administrator 4 Joomla 2.5   User Lost Super Administrator Access

Joomla 2.5 – Change User ID to have Super Administrator Access

  • Change field to the following value:
    • group_id = 8
  • Click on ‘Go’

Now if you view your  _user_usergroups_map table, you will see that your Super User account is correctly mapped to Group ID = 8.  You can log into your Joomla 2.5 administrator backend and access your site as a Super Administrator User.

cmsmind joomla 2 5 change to super administrator 5 Joomla 2.5   User Lost Super Administrator Access

Joomla 2.5 – Super Administrator has Super User Access

SMS PORTAL AND JOOMLA TUTORIAL

Bulk SMS Portal Creator V4 Complete Manual

14 October 2016 - 153Views

SMS Portal Creator is the

...

How to fix it No installation plugin has been enabled - Joomla 3.6

09 September 2016 - 292Views

Joomla 3.6 is a new

...

DND Policy - How to Deactivate it

13 August 2016 - 413 Views
...

Guest Level Members

28 July 2016 - 304Views

If you are interested in

...

How to Run a Successful SMS Marketing Campaign

12 June 2016 - 626Views

SMS - invest in

...

Put a background image or color on an article

29 September 2015 - 1003 Views
...

How to Fix jquery Issue in joomla

21 July 2015 - 1543Views

How to JQUERRY ISSUE in

...

How to Fix SMS Counters Issue

21 July 2015 - 1694Views

How to JQUERRY ISSUE in

...

Accessing cPanel

07 February 2014 - 1571 Views

To access

...

An Introduction to Branding cPanel for your users

07 February 2014 - 1509Views

How to Create a new

...

An introduction to reseller access within WHM

07 February 2014 - 2691Views

What is reseller access

...

Automated database backup for SPC High Earner

06 February 2014 - 1345 Views

SPC high earner comes

...

Creating MySQL Database and User

22 February 2014 - 1845Views

Creating a MySQL database

...

Cron Settings for SMS Scheduling

06 February 2014 - 1864 Views
  A
...

Download Now

09 March 2014 - 3678Views

Here is a PDF version of

...

HOW TO ADD MENU IN JOOMLA 2.5

05 February 2014 - 6215Views

To create a

...

How To Add New User in Joomla Using PHPMyAdmin

15 March 2014 - 1824 Views

If you need to create 

...

How to Choose the Best Web Hosting Provider

07 February 2014 - 1520Views
...