How to Reinstate Admin Privileges


I accidentally unchecked the admin user group under People for our one admin user and it immediately locked me out. Now nobody can access the admin panel to change the permission back to what it was.

How do I create a new admin account to gain access again or reinstate the admin privileges for the account that was removed?


Depends upon your database, but use the following SQL to find the correct user:.
select * from core_user
It’s the first column you’re interested in. Assuming, it’s user 1, you then use:
Update core_user set is_superuser=1 where id=1
to set them to admin