MyBB Community Forums - Password Problem

Hi to all

I got a problem, I changed my admin password in the forum and can't login anymore.
Only access to the provider hosting . Any changes to set a new admin password in public html , settings.php or other setting Option to rescue my forum ?

Thanks in advance
Have a nice day to all

Just perform a password reset and you'll get an email.

You can do this in the database if you have access to phpMyAdmin.

See this post: https://community.mybb.com/thread-85406-...#pid624568

Once you update the password via that method in the database you'll want to reset it again via MyBB's AdminCP though.

Thank you will try and .... Cry 😀

😀😀😀
OMG
Thanks a lot Taylor M , Nathan Melcom

With you guys I found out that my password is ok , my admin user was wrong typed in the beginning

Thanks a lot, working well now

Have a nice day

Ps. Is there a option to see the real password or only the code ?
Had once a problem with a forum where I was a member only. And somebody took over my account, he claimed later he got the database and all passwords .

Hi Matt

My I ask you something please , in one of your help posts

https://community.mybb.com/thread-85406-...#pid624568

You wrote :

Run this query in phpMyAdmin:

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

This will reset your password to test, change the 1 to your UID if it isn't 1.

I did and got the message that

SCREENSHOT
Table_user doesn't exist
https://postimg.cc/FY7pF5B0
https://i.postimg.cc/QdqybjgY/sql.jpg

THANKS IN ADVANCE

In case Matt doesn't see your post, or only gets to it late: I suspect that you have your database prefix set to something other than mybb_. Check the value of $config['database']['table_prefix'] in inc/config.php, and substitute whatever it is for mybb_ in mybb_users.

Hi Laird,

Thanks for your help , I di so but still no success. I changed the database prefix but nothing . The update only change the password into ,test, or the username too? Into ,admin, maybe?
Anyway I delete the entire forum and install all new . But for studying I would like to know how to change the password, just in case .

(2024-03-06, 03:11 AM)Sarah85 Wrote: [ -> ]Hi Laird,

Thanks for your help , I di so but still no success. I changed the database prefix but nothing .

Any error message?

(2024-03-06, 03:11 AM)Sarah85 Wrote: [ -> ]The update only change the password into ,test, or the username too? Into ,admin, maybe?

The password only. You need to supply the user ID (uid) corresponding to the user whose password you want to change. The query Matt provided uses a user ID (uid) of one, which corresponds to the first board user, who is created automatically and is usually the super-admin, usually with username admin. If you want to change another user's password, you need to supply the correct user ID for that user.

Thanks lot for help