MyBB Community Forums › Community Archive › Archived Forums › Archived Development and Support › MyBB 1.6 › 1.6 General Support v
Demoted myself HELP

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode
Not Solved Demoted myself HELP
giannismalaka Offline
Posts: 17
Threads: 4
Joined: Aug 2012
Reputation: 0
#1
Not Solved 2012-08-11, 11:45 AM
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
Find
Euan T Offline

Security

Web
Posts: 15,129
Threads: 240
Joined: Jun 2009
Reputation: 703
#2
Not Solved 2012-08-11, 11:47 AM
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.
Website Find
giannismalaka Offline
Posts: 17
Threads: 4
Joined: Aug 2012
Reputation: 0
#3
Not Solved 2012-08-11, 11:48 AM
phpmyadmin from firezilla?
Find
Euan T Offline

Security

Web
Posts: 15,129
Threads: 240
Joined: Jun 2009
Reputation: 703
#4
Not Solved 2012-08-11, 11:50 AM
No, you normally access phpmyadmin via your host's control panel (cpanel).
Website Find
Vernier Away

Former Staff
Posts: 1,859
Threads: 113
Joined: Nov 2011
Reputation: 194
#5
Not Solved 2012-08-11, 11:51 AM (This post was last modified: 2012-08-11, 11:52 AM by Vernier.)
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 Smile

Edit: Ninja'd.
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.

MyBBatically - A quick and easy way to update your board!
Website Find
giannismalaka Offline
Posts: 17
Threads: 4
Joined: Aug 2012
Reputation: 0
#6
Not Solved 2012-08-11, 11:52 AM
My host is 00webhost.com i said to try this one first, ok i click phpmyadmin and it says list of current databases none
Find
Euan T Offline

Security

Web
Posts: 15,129
Threads: 240
Joined: Jun 2009
Reputation: 703
#7
Not Solved 2012-08-11, 11:53 AM
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.
Website Find
giannismalaka Offline
Posts: 17
Threads: 4
Joined: Aug 2012
Reputation: 0
#8
Not Solved 2012-08-11, 11:57 AM (This post was last modified: 2012-08-11, 12:00 PM by giannismalaka.)
http://imgur.com/nGVje,gsKTO i can still connect on firezilla though but with different login details
Find
Euan T Offline

Security

Web
Posts: 15,129
Threads: 240
Joined: Jun 2009
Reputation: 703
#9
Not Solved 2012-08-11, 12:10 PM
Click the "Enter phpmyadmin" link...
Website Find
giannismalaka Offline
Posts: 17
Threads: 4
Joined: Aug 2012
Reputation: 0
#10
Not Solved 2012-08-11, 12:11 PM
i did.. go on the 2nd imgur page lol
Find


Forum Jump:


Users browsing this thread: 1 Guest(s)