MyBB Community Forums

Hi, i have problem with admincp same here: http://community.mybb.com/post-563781.html

I was tried as post2, but not solve? How can i fix this?

Thank!

Does the admin username+password still work for the normal login?

Did you edited your usergroup ? If so then you just need to run the following query;

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

Replace X with your UserID.

(2011-06-02, 10:04 AM)Aries-Belgium Wrote: [ -> ]Does the admin username+password still work for the normal login?

No, if you enter incorrect password, a red line will be appear to notice.

(2011-06-02, 10:06 AM)Yaldaram Wrote: [ -> ]Did you edited your usergroup ? If so then you just need to run the following query;

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

Replace X with your UserID.

Thank, but not effect
My admin with id 1

Try this: http://community.mybb.com/thread-90809-p...#pid662568
That will change your password to 'test'. Change your password again once you are able to login.

(2011-06-02, 10:39 AM)Aries-Belgium Wrote: [ -> ]Try this: http://community.mybb.com/thread-90809-p...#pid662568
That will change your password to 'test'. Change your password again once you are able to login.

Yes, i was tried this, but not

Okay, try this. Run this query phpMyAdmin:

INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `usergroup`) VALUES (NULL, 'tmpadmin', '098f6bcd4621d373cade4e832627b4f6', '', '4', '');

Make sure you check if 'mybb_' is the correct prefix.

Open the file /inc/config.php and comment out this:

$config['super_admins'] = '1';

It should look like this now:

//$config['super_admins'] = '1';

Save that file.

Try to login with 'tmpadmin' as username and 'test' as password.
Now navigate to Users & Groups > Users > (click your first admin user). And change the password there.

If that works, log out and try to login with your first admin using the new password.
Delete the tmpadmin user and uncomment (= remove the // in front of it) the line described above in /inc/config.php.

Thank Aries-Belgium, when i run query, error occur

mysql> INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `usergroup`) VALUES (NULL, 'tmpadmin', '098f6bcd4621d373cade4e832627b4f6', '', '4', '');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql>

I'm 'locating' mydatabase

Try this:

INSERT INTO `mybb_users` (`uid`, `username`, `password`, `salt`, `usergroup`) VALUES (NULL, 'tmpadmin', '098f6bcd4621d373cade4e832627b4f6', '', '4');

Sorry.

Thank, i don't know why tmpadmin can't login . Although i did steps above