Joomla 3 - How to Change user type in PhpMyAdmin

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

How to Change user type under PhpMyAdmin for Joomla 3 or should we say how to change user type through Joomla database. There are times when we fall in a tight situation when the access permission is lost and or changed accidentally. You simply cannot edit/modify/change anything on your Joomla site. Well, you need not worry as there are ways to handle this situation. You can simply get inside the database of your site and deal with it. You can change the user permission / group / role / type through Joomla database.

If you've lost the permissions to your Joomla Admin panel, here are the steps on how to change user roles / group under PhpMyAdmin for your Joomla Site.

  1. Go to PhpMyAdmin (SQL Database) and select the database of your Joomla
  2. Now select the users table and make a note of ID on your username.
  3. Now go to user_groups table and record the ID of Super Users from this Table
  4. Now locate user_usergroup_map table and Edit the User in match with ID of your username.
  5. Change the group_ID value to super user or any other role ID which you just recorded from the user_usergroup_map table.
  6. Click on go button.

Go back to Joomla administration page and verify your access level.

Applies to

  • Applies to Joomla 3.x and above
  • May apply to Joomla 2.x series (I personally did not try).

Did you Find it helpful?, drop a line and share it forward to help others. Have a nice day.

About the Author
Syed Hussaini
Author: Syed HussainiEmail: This email address is being protected from spambots. You need JavaScript enabled to view it.
Web Developer & Consultant
Brief Bio
With over 12+ Years of experience, he holds a great knowledge of variety of applications and business practices besides Web Analytics, Web Development on CMS & Web Technologies, eLearning Solutions such as Adobe Captivate and Camtasia.