MyBB Community Forums

Full Version: Accidently demoted myself
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I accidently demoted myself into a member and I was the only Admin on my site. Can anyone please help me? I want to be an Admin again.
Jst go in to your database via phpmyadmin or similar and in the mybb_users table find you user name, most likely the first one and then edit the record and edit your group id back to 4(or what ever your admin group id is), there is a query you can run but i'm not much good with sql and not sure what the query is.
Run this SQL query in phpMyAdmin (How to run SQL Queries using phpMyAdmin):

UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1'
Same thing happened to me a while ago.

http://community.mybb.com/thread-69734.html
ninja'd
Wow guys. Such a helpful community. Thanks, I'll post back with the results!
(2011-06-14, 11:03 PM)faviouz Wrote: [ -> ]Run this SQL query in phpMyAdmin (How to run SQL Queries using phpMyAdmin):

UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1'

Thats what i was trying to do but i wasn't sure how to format the query.
IT WORKED!! Thank you guys so much!

I gave you guys all +1 Rep Big Grin