MyBB Community Forums

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

Diminished

2010-08-18, 11:10 AM
Hey,

What's the phpMyAdmin code to make an admin account with the username admin1 and password admin or something like that? I know there is one but I forgot it.

It's not for my forum, but a forum I'm working on.

I'm basically trying to upgrade a site to 1.6 and it says "Please enter your username and password to begin the upgrade process. You must be a valid forum administrator to perform the upgrade.
Login" so I need an admin account.

Thanks.

Alan S.

2010-08-18, 12:01 PM
Not sure how you set a password, but if you have existing account:

UPDATE `mybb_users` SET `usergroup` = '4' WHERE uid = '*'

Where * is your user ID.
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Make an admin account