MyBB Community Forums

A hostee of mine was editing her headers and now she cant login. She is the main admin no one else has any powers. So is there a way to reset her password for her?

run sql query {replace X with user ID (eg. 1)}

UPDATE `mybb_users` SET `password`=MD5('newpassword'), `salt`='' WHERE `uid`=X;

how will i know what the password is? is that the 'newpassword' thing in the sql query?

^ newpassword can be anything which should be used for the next login. after logging in, she can change it to her choice !!

thank you!!