Reset admin password

[edduvs]

Hi there, i want to reset my admin user password, but i closed the board like two months ago, and if i go to lost password, i get the board closed message. So how can i reset my admin pass through this board closed message.

Best regards,
Edi

[Matt]

Run this query in phpMyAdmin:

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

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

[Yaldaram]

Go to: CPanel > Database Management > phpmyadmin > Click on "SQL" tab > and enter the following query and Press "Go"

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

Login with test as the password.

[edduvs]

Oh , thats why my simple password didn't work ie needed another column updated )... thanks yaldaram, matt you too.

[Yaldaram]

Thanks.