Unmaintained Password Reset Query

life saver, I thought I was done. THank you for making this. I locked my self out while changing my password and wasnt able to send an email for forgot password. But with this I was able to reset the password from my database.

5 stars because this saved me after I did something stupid. Thanks, Jake! :)

Perfect. Saved the day when I forgot my password when I upgraded to 1.3.

Still working in 2021 with XF 2.2.6 PAtch 2 !! Many thanks for this useful SQL query mister Jake Bunce !!

Doing a migration from vBulletin 3.8 to Xenforo and needed a way to globally "scrub" all passwords to force all users to reset them on first login after an attack potentially compromised the vB user table. This query is an excellent base to do that from if you replace the simple password with something unguessable (e.g. a guid). Thanks!

What are you supposed to replace the "1" with? If the admin username is "1" then shouldn't you leave it as "1" ?

I forgot to rate this previously. Awesomely useful advice, Jake. Thank you.

exactly what I was looking to do