MyBB

kjaonline · 11-19-2008, 02:14 AM

Been stupid. I used a randomly generated password and forgot what it is.. I tried recovering but when I get the randomly generated password from MyBB it wont work.. saying that Im using the wrong password

how do I recover the password using the DB? Sad

seeker · (This post was last modified: 11-19-2008 02:20 AM by seeker.)

1) Use a test forum, fresh install, or any other copy of MyBB.
2) Go into that DB and find the users table.
3) Select a user for which you know the password (yourself)
4) Copy the password and salt into the first user on the forum you are locked out of.

Now you can login Smile

Stephon · 11-19-2008, 03:18 AM

Quote:You may be unlucky enough to forget your admin password and not be able to retrieve it from the Lost Password link. If this is the case, all hope is not lost. In PHPMyAdmin, or some other database manager, run this query:

PHP Code:

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

Change the X to your user ID and make sure your table prefix is correct. This will turn your password to simply 'test'. Now, log in, and change your password... and try and remember it

I take no credit for this Toungue

Source: http://www.learnmybb.com/forums/showthread.php?tid=61

**MattRogowski** · (This post was last modified: 11-19-2008 10:22 AM by MattRogowski.)

And actually neither do I as I saw Dennis post it first!! Toungue

But that's the easiest way IMO, rather than having to create a new user.

seeker · 11-19-2008, 04:39 PM

It's always great to learn a better way.

kjaonline · (This post was last modified: 11-20-2008 10:34 AM by kjaonline.)

thanks for this guys Smile

Damn this still doesnt work..
well as an admin I changed my username to something else.. does that affect anything?

jgioello · 02-12-2010, 03:51 AM

(11-19-2008 03:18 AM)Stephon Wrote:
Quote:You may be unlucky enough to forget your admin password and not be able to retrieve it from the Lost Password link. If this is the case, all hope is not lost. In PHPMyAdmin, or some other database manager, run this query:

PHP Code:

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

Change the X to your user ID and make sure your table prefix is correct. This will turn your password to simply 'test'. Now, log in, and change your password... and try and remember it

I take no credit for this

Source: http://www.learnmybb.com/forums/showthread.php?tid=61

Thank you soooo much. I will try it and see what happens.