MyBB Community Forums

So while i was fixing rank and all on admin cp i accidentially demoted myself and i have access to mod cp only. Since i am new to mybb and sql in general can you please tell me what to do? I use firezilla

Open phpmyadmin and run this query:

UPDATE mybb_users SET usergroup = 4 WHERE uid = 1

That's assuming your user ID is 1 and you have the default mybb_ table prefix.

phpmyadmin from firezilla?

No, you normally access phpmyadmin via your host's control panel (cpanel).

Run that in PHPMyAdmin.

Click your database on the right hand side <, then click "SQL" (tab at the top), then enter the query Euantor provided. Click run. Now try login to Admincp

Edit: Ninja'd.

My host is 00webhost.com i said to try this one first, ok i click phpmyadmin and it says list of current databases none

You must have a database to be able to run MyBB so I don't see why it would list 0 databases. Could you perhaps screenshot what you're seeing? I've never used a free host like 000webhost before.

http://imgur.com/nGVje,gsKTO i can still connect on firezilla though but with different login details

Click the "Enter phpmyadmin" link...

i did.. go on the 2nd imgur page lol