MyBB Community Forums

Full Version: No Admin?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Some how my account as admin was changed back to a registered user and i was the only admin on the site. I figure there is some way of changing all of the php files since I am the website host also and changing it back or creating a new user that is an admin. Thanks for any help.
No you don't need to do anything with any files, just run this query in phpMyAdmin:

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

Check your table prefix and UID. Chances are you setup a group promotion which included the admin usergroup.
I just tried looking at that and I am confused as hell. I never do anything with PHP...just HTML and CSS. I just don't understand PHP. Is there any easy step by step way to fix this?
Well, it isn't PHP, it's SQL, but you just need to copy and paste that into the SQL box in phpMyAdmin. Unless you want to edit the database manually, the query is much easier.