Unban Yourself

Suppose you are only admin and you've banned yourself, then?
Freaky, but accident happens ...

Go to your hosts control panel and launch phpMyAdmin.

Run the following commands:

next ...



You are unbanned and assigned to admin again!!!



Note:

Assuming your UID is 1 (default for first member : admin).

Assuming your database table prefix is mybb_ (default), if not, change what is.

Assuming your usergroup is 4 (default for Administrators), if not, change what is.




Credits to original creator

Will this also work if someone breaks into your forum and bans you? and where do i have to run the command? (Sorry for noob question)

20-08-2015, 10:00 PM

redd Wrote: Will this also work if someone breaks into your forum and bans you? and where do i have to run the command? (Sorry for noob question)

It's a MySQL query, you need to run it in phpmyadmin, or if you're using a VPS, just login to your MySQL database.

As far as a I know, no one can ban a superadmin (the owner of the forum).
Without critical changes to the forum that is.

20-08-2015, 10:26 PM

Faded Wrote:

20-08-2015, 10:00 PM

redd Wrote: Will this also work if someone breaks into your forum and bans you? and where do i have to run the command? (Sorry for noob question)

It's a MySQL query, you need to run it in phpmyadmin, or if you're using a VPS, just login to your MySQL database.

As far as a I know, no one can ban a superadmin (the owner of the forum).
Without critical changes to the forum that is.

Ah thanks man sadly enough they did manage to ban superadmin :(

20-08-2015, 10:41 PM

redd Wrote:

20-08-2015, 10:26 PM

Faded Wrote:

20-08-2015, 10:00 PM

redd Wrote: Will this also work if someone breaks into your forum and bans you? and where do i have to run the command? (Sorry for noob question)

It's a MySQL query, you need to run it in phpmyadmin, or if you're using a VPS, just login to your MySQL database.

As far as a I know, no one can ban a superadmin (the owner of the forum).
Without critical changes to the forum that is.

Ah thanks man sadly enough they did manage to ban superadmin :(

Are you sure it was an superadmin? Superadmins are in the config file, and as far as I'm aware, there can only be one.

20-08-2015, 10:51 PM

Faded Wrote:

20-08-2015, 10:41 PM

redd Wrote:

20-08-2015, 10:26 PM

Faded Wrote:

20-08-2015, 10:00 PM

redd Wrote: Will this also work if someone breaks into your forum and bans you? and where do i have to run the command? (Sorry for noob question)

It's a MySQL query, you need to run it in phpmyadmin, or if you're using a VPS, just login to your MySQL database.

As far as a I know, no one can ban a superadmin (the owner of the forum).
Without critical changes to the forum that is.

Ah thanks man sadly enough they did manage to ban superadmin :(

Are you sure it was an superadmin? Superadmins are in the config file, and as far as I'm aware, there can only be one.

Yes it was a superadmin and when i tried logging in it said i was banned. but i think they banned my ip though

I am 99% MyBB makes you (the owner) prone to being banned. The first account that you sign up anyway with MyBB in the install configuration page on a fresh install.

I've done this before ahaha, I deleted myBB and started it again... Thank god it was just localhost haha.

I guess this may come in handy, thanks for taking the time to writing it. I'll save it to my tutorials folder - may need it in the future

Thanks for this trick! (: