Resource icon

Password Reset Query

Jake Bunce

XenForo moderator
Staff member
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.

Rich (BB code):
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...
 
Top