Unban Yourself

by iHydra - 17-08-2015, 06:48 AM
Closed Account
Posts:
239
Joined:
Jul 2015
Likes:
9
Credits:
27
Reputation:
3
1 Year of Service
#1
OP
Posted: 17-08-2015, 06:48 AM
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:
Code:
DELETE FROM mybb_banned WHERE uid=1

next ...

Code:
UPDATE mybb_users SET usergroup=4 WHERE uid=1


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
Evilish
10-09-2015, 05:56 PM
H
10-09-2015, 04:41 PM
Active Member
Posts:
346
Joined:
Aug 2015
Likes:
5
Credits:
24
Reputation:
7
1 Year of Service
#2
Posted: 20-08-2015, 09:00 PM
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)
­
Paradigm
Posts:
8,479
Joined:
Apr 2015
Likes:
536
Credits:
6,293
Reputation:
119
Head Staff
1 Year of Service
#3
Posted: 20-08-2015, 09:26 PM
(20-08-2015, 09: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.
fdigl
https://www.youtube.com/watch?v=--zku6TB5NY
[Image: udzanx.png]

Send an email: faded@nulledbb.com

(16-06-2016, 03:28 PM)bingo Wrote: only she know coins one side not other side. life is easy she think

Active Member
Posts:
346
Joined:
Aug 2015
Likes:
5
Credits:
24
Reputation:
7
1 Year of Service
#4
Posted: 20-08-2015, 09:41 PM
(20-08-2015, 09:26 PM)Faded Wrote:
(20-08-2015, 09: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 :(
­
Paradigm
Posts:
8,479
Joined:
Apr 2015
Likes:
536
Credits:
6,293
Reputation:
119
Head Staff
1 Year of Service
#5
Posted: 20-08-2015, 09:51 PM
(20-08-2015, 09:41 PM)redd Wrote:
(20-08-2015, 09:26 PM)Faded Wrote:
(20-08-2015, 09: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.
fdigl
https://www.youtube.com/watch?v=--zku6TB5NY
[Image: udzanx.png]

Send an email: faded@nulledbb.com

(16-06-2016, 03:28 PM)bingo Wrote: only she know coins one side not other side. life is easy she think

Active Member
Posts:
346
Joined:
Aug 2015
Likes:
5
Credits:
24
Reputation:
7
1 Year of Service
#6
Posted: 20-08-2015, 10:01 PM
(20-08-2015, 09:51 PM)Faded Wrote:
(20-08-2015, 09:41 PM)redd Wrote:
(20-08-2015, 09:26 PM)Faded Wrote:
(20-08-2015, 09: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
Junior Member
Prime
Posts:
89
Joined:
Sep 2015
Likes:
8
Credits:
74
Reputation:
0
1 Year of Service
#7
Posted: 10-09-2015, 04:00 PM
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.
y u so shit
Posts:
6,598
Joined:
Feb 2015
Likes:
135
Credits:
5,920
Reputation:
93
2 Years of Service
#8
Posted: 10-09-2015, 04:42 PM
I've done this before ahaha, I deleted myBB and started it again... Thank god it was just localhost haha.
The Pengest Turkey

[Image: The-Chicken-Connoisseur-PENGEST-TURKEY-1-1.gif]

Novice
Posts:
46
Joined:
Feb 2015
Likes:
2
Credits:
1
Reputation:
1
2 Years of Service
#9
Posted: 16-09-2015, 12:56 PM
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 Tongue
Novice
Posts:
42
Joined:
Sep 2015
Likes:
4
Credits:
41
Reputation:
0
1 Year of Service
#10
Posted: 16-09-2015, 06:36 PM
Thanks for this trick! (:
The last reply on this thread is older than a month. Please do not unnecessarily bump it.
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)