MyBB Community Forums

Full Version: Database - Admin Changes
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi on the admin cp I acedently changed my usergroup permisons so that i can view the admin cp. Im trying to change it in phpmyadmin but I dont know which table of feild I need to edit.
I really don't understand why people do this Undecided

UPDATE `mybb_usergroups` SET `cancp` = '1' WHERE `gid` = '4';
DELETE FROM `mybb_datacache` WHERE `title` = 'usergroups';
ACP > Tools & Maintenance > Cache Manager > usergroups > Rebuild Cache.
Sorry what do I do with the codes?
You run them in phpMyAdmin, which you can access by your hosts control panel.
I ran the first one in phpmyadmin. But I still cant access the admin.
Sorted. Ty Smile
Yes, you need to do all 3 steps before it will work properly.