Resource icon

Unmaintained Password Reset Query

Overview Reviews (8) Discussion
You can use this query to reset a user's password. It is especially useful if you forget your admin password.

You need to replace new-password and 1 (the user_id). You don't have to change salt, but if you do then both instances need to be the same.

Rich (BB code): 
UPDATE...
You do not have permission to view the full content of this resource. Log in or register now.
  • Like
  • Love
Reactions: ebrasha, azzAzz, lelouchfans and 44 others
Author
Jake Bunce
Views
4,881
First release
Last update

Ratings

5.00 star(s) 8 ratings
Join the discussion

More resources from Jake Bunce

Share this resource

Latest reviews

N
Still working in 2021 with XF 2.2.6 PAtch 2 !! Many thanks for this useful SQL query mister Jake Bunce !!
Upvote 1 Downvote
X
What are you supposed to replace the "1" with? If the admin username is "1" then shouldn't you leave it as "1" ?
Jake Bunce
Jake Bunce
that is the user_id number
Upvote 0 Downvote
RandallC
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.
Upvote 0 Downvote
T
Perfect. Saved the day when I forgot my password when I upgraded to 1.3.
Upvote 0 Downvote
K
exactly what I was looking to do
Upvote 0 Downvote
Kevin
5 stars because this saved me after I did something stupid. Thanks, Jake! :)
Upvote 0 Downvote
Ronin Storm
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!
Upvote 0 Downvote
Chris D
I forgot to rate this previously. Awesomely useful advice, Jake. Thank you.
Upvote 0 Downvote
Read more…
Top Bottom