Password Reset Query

[Jake Bunce]

Jake Bunce submitted a new resource:

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

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.

UPDATE xf_user_authenticate
SET data = BINARY
    CONCAT(
        CONCAT(
            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('new-password')...

Read more about this resource...

 

[MARGO]

https://xenforo.com/community/threads/password-reset-query.25632/

 

[Ozzy47]

https://xenforo.com/community/threads/password-reset-query.25632/

Okay, that was for XF1, this is for XF2