1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Password Reset Query

A database query to reset a user's password. Useful for recovery of admin login.

  1. Jake Bunce
    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.

    Code:
    UPDATE...
    You do not have permission to view the full content of this resource.

Recent Reviews

  1. Deathstarr
    Deathstarr
    5/5,
    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.
  2. Type RA
    Type RA
    5/5,
    Perfect. Saved the day when I forgot my password when I upgraded to 1.3.
  3. KamelJabber
    KamelJabber
    5/5,
    exactly what I was looking to do
  4. Kevin
    Kevin
    5/5,
    5 stars because this saved me after I did something stupid. Thanks, Jake! :)
  5. Ronin Storm
    Ronin Storm
    5/5,
    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!
  6. Chris D
    Chris D
    5/5,
    I forgot to rate this previously. Awesomely useful advice, Jake. Thank you.