Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to manually reset a password via phpmyadmin
#1
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".
-Paul H.

Cogisne lingua latina?
Reply
#2
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')
No longer involved in the MyBB project.
Reply
#3
Ah, that would be better, yes.
-Paul H.

Cogisne lingua latina?
Reply
#4
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.
Reply
#5
(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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)