MyBB Community Forums

Full Version: How to manually reset a password via phpmyadmin
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
This tutorial will show you how to manually reset a MyBB password.

Run this query in phpmyadmin:

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

Replace useruid with the uid of the user whose password you want to reset.

That will reset that user's password to "test".
A better method:

UPDATE mybb_users SET password = MD5('my new password'), salt = '' WHERE uid = 'x'; 

No need to change it via the user cp afterwards. Smile

(Plus I believe '098f6bcd4621d373cade4e832627b4f6' is 'test')
Ah, that would be better, yes.
Why would that be better? Surely the user would want a unique password after the initial password reset, that only he or she knows. Therefore whats the point in setting a specific password as opposed to setting a default "test" password ? The second method is really only any use when resetting your own password.
(2011-12-26, 02:05 PM)Frank.Barry Wrote: [ -> ]Why would that be better? Surely the user would want a unique password after the initial password reset, that only he or she knows. Therefore whats the point in setting a specific password as opposed to setting a default "test" password ? The second method is really only any use when resetting your own password.

If you're just resetting it for them because the password reset tool isn't working and they've contacted you directly to get it fixed, this is a perfectly fine way of doing it.