concat

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 =...