MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Accidently demoted myself!
Full Version: Accidently demoted myself!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

PileofSalt

2011-10-30, 04:53 PM
Hey guys, I have a problem. I accidently changed my rank to Moderator on my Forum and can't access the AdminCP anymore. I read some things and saw people saying to add a Query in phpMyAdmin. But I have no idea what the hell it is. I'm using 000WebHost and FileZilla to manage my things. Please help! Sad

ranjani

2011-10-30, 04:58 PM
see common SQL queries - how to run them ...

Yaldaram

2011-10-30, 05:34 PM
PHP Myadmin is in your hosting control panel. Most commonly found in Database Management pages.

Once you enter the PHPMyAdmin, go to select your forum's database and then SQL tab.Then enter the following query and Press GO;
UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = 'X'

Replace X with your UserID.

PileofSalt

2011-10-30, 05:36 PM
Okay I installed some program called XAMPP. I downloaded it and ran it and clicked Admin on "Apache" and it took me to this page: http://localhost/xampp/

I clicked on phpMyAdmin under Tools. I'm at
http://localhost/phpmyadmin/

Now what do I do? Don't I need to add my forum files or something?

ranjani

2011-10-30, 05:44 PM
^ I do not understand why are you doing it on XAMPP ; you should be having your web host
control panel from 000WebHost . your forum's database exists there . you need to work there ...

Yaldaram

2011-10-30, 05:48 PM
Are you running your forum on localhost or on live server ?

PileofSalt

2011-10-30, 05:50 PM
(2011-10-30, 05:44 PM)ranjani Wrote: [ -> ]^ I do not understand why are you doing it on XAMPP ; you should be having your web host
control panel from 000WebHost . your forum's database exists there . you need to work there ...

Ooohh okay! Thanks!! I was just watching a YouTube video about installing it on XAMPP Confused

It worked! Thanks so much guys!! Big Grin
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Accidently demoted myself!