Not Solved [Security] i can not recover my admin password.
#8
Not Solved
(2018-08-14, 07:37 AM)Serpius Wrote:
(2018-08-14, 07:28 AM)gunrose2003 Wrote:
(2018-08-14, 05:27 AM).m. Wrote: once again try using below SQL queries
UPDATE `mybb_adminoptions` SET `loginattempts` = '0', `loginlockoutexpiry` = '0' WHERE `uid` = '1';
UPDATE `mybb_users` SET `salt` = '', `password` = 'actualRequiredPassword' WHERE `uid` = '1';

i tried 
 0 rows affected. (Query took 0.0003 seconds.)
UPDATE `mybb_adminoptions` SET `loginattempts` = '0', `loginlockoutexpiry` = '0' WHERE `uid` = '1'

 0 rows affected. (Query took 0.0004 seconds.)
UPDATE `mybb_users` SET `salt` = '', `password` = 'test' WHERE `uid` = '1'
it seem does not work

See this prefix? mybb_ That's the default prefix that MyBB uses during the first installation.

Are you using the SAME prefix or are you using a different prefix for your database?

When you are in the SQL query, double check to make sure you're using the correct prefix.
I did not change any prefix before.

(2018-08-14, 07:49 AM).m. Wrote: Serpius has a valid point.

perhaps its better to manually register a new user account (by using another working email account)
and temporarily change its user group to admin group, login to forum admin panel & change password
of the main admin
...

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

I tried to registered a new user account, but the problem is that i can not find my new account id/UID in "mybb_users",
Whats happened ?
Reply


Messages In This Thread
RE: i can not recover my admin password. - by .m. - 2018-08-14, 05:27 AM
RE: i can not recover my admin password. - by gunrose2003 - 2018-08-14, 07:50 AM
RE: i can not recover my admin password. - by .m. - 2018-08-14, 07:49 AM
RE: i can not recover my admin password. - by .m. - 2018-08-14, 10:57 AM
RE: i can not recover my admin password. - by .m. - 2018-08-14, 12:25 PM
RE: i can not recover my admin password. - by .m. - 2018-08-14, 01:07 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)