MyBB Community Forums

Full Version: Locked out of my board, failed phpmyAdmin password reset
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I've recently re-uploaded all files related to an old forum of mine. I've later imported the last .sql backup I had.

Now, I couldn't recall my admin password, so I used phpmyadmin to run this query (table prefix has been updated, obviously):

UPDATE `mybb_users` SET `salt` = '', `password` = '098f6bcd4621d373cade4e832627b4f6' WHERE `uid` = '1';

The query worked, so I tried to login and I got a message claiming that my user/pass is wrong.

I went back to the users table to find out that "salt" column is now filled again and "password" contains a different value. Whenever I try to login, either via ACP or just using front-end login page, I get the same error.

The worst thing is that I had my board closed, so I can't even reach the Password Lost form.

What can I do?
Try the following using plain text:

UPDATE `mybb_users` SET `salt` = '', `password` = 'changeme' WHERE `uid` = '1';
(04-18-2019, 12:42 AM)Wires Wrote: [ -> ]Try the following using plain text:

UPDATE `mybb_users` SET `salt` = '', `password` = 'changeme' WHERE `uid` = '1';

Worked. Thank you.

But I still cannot understand what happened
(04-18-2019, 04:24 PM)ShadowOne Wrote: [ -> ]
(04-18-2019, 12:42 AM)Wires Wrote: [ -> ]Try the following using plain text:

UPDATE `mybb_users` SET `salt` = '', `password` = 'changeme' WHERE `uid` = '1';

Worked. Thank you.

But I still cannot understand what happened

The reason is previously you were using a Salt(098f6bcd4621d373cade4e832627b4f6) in place of password. In past, you had to add salted password while editing the SQL.
I wrote about it in 2017 Smile
https://wallbb.co.uk/reset-admin-password-mybb/
(04-19-2019, 06:09 AM)WallBB Wrote: [ -> ]
(04-18-2019, 04:24 PM)ShadowOne Wrote: [ -> ]
(04-18-2019, 12:42 AM)Wires Wrote: [ -> ]Try the following using plain text:

UPDATE `mybb_users` SET `salt` = '', `password` = 'changeme' WHERE `uid` = '1';

Worked. Thank you.

But I still cannot understand what happened

The reason is previously you were using a Salt(098f6bcd4621d373cade4e832627b4f6) in place of password. In past, you had to add salted password while editing the SQL.
I wrote about it in 2017 Smile
https://wallbb.co.uk/reset-admin-password-mybb/

Oh, I see.
Thank you! Smile
similar issues here myself, tried running the SQL but made no difference.
Even if i can log in eventually will this mean other members cannot?
(04-20-2019, 02:12 PM)AstroTiger Wrote: [ -> ]similar issues here myself, tried running the SQL but made no difference.
Even if i can log in eventually will this mean other members cannot?

Once you recover your Admin account, you may just open the board and tell your users to reset their passwords.