Not Solved Unable to reset password from database
#1
Not Solved
I've been locked out of my forum because I am not able to reset my admin account password. I have tried numerious of ways.

Reset through mail - didn't work, I got the initial mail with reset link, clicked it, didn't get another e-mail with generated password.

Reset my password directly through DB with command:
UPDATE `mybb_users` SET `salt` = '', `password` = '098f6bcd4621d373cade4e832627b4f6' WHERE `uid` = '1'; 


It successfully updated the query, but when I tried to log in, it failed and I checked the DB generated completely another password for some reason.

I also tried this query (probably the same as above):
UPDATE `mybb_users` SET `password` = MD5('test'), `salt` = '' WHERE `uid` = '1'; 

The same thing happened.

How do I gain access back? Any help is appreciated!
Reply
#2
Not Solved
This has actually happened to me a few times. Best way is to create a new user, use the database to set the usergroup of that new user to 4 (administrator group), login to ACP with new account, reset your main account password.
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply
#3
Not Solved
(2018-07-15, 06:37 PM)Wires Wrote: This has actually happened to me a few times. Best way is to create a new user, use the database to set the usergroup of that new user to 4 (administrator group), login to ACP with new account, reset your main account password.

I just tried this and I can't. I get an error:
Quote:You do not have permission to edit this user because you are not a super administrator.
Reply
#4
Not Solved
..inc/config.php add the new user's UID to $config['super_admins']. For example:

$config['super_admins'] = '1,3,10';
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply
#5
Not Solved
(2018-07-15, 06:47 PM)Wires Wrote: ..inc/config.php add the new user's UID to $config['super_admins']. For example:

$config['super_admins'] = '1,3,10';

Ok, that worked. Thanks for the help. Maybe pinging some of the devs who work on MyBB can take a look at why the automatic password reset is happening.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)