Compatible XF 2.x versions 2.0
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.
It's ugly and only uses SHA1, but it works. If you are paranoid about security then you should reset your password again in the Admin CP once you regain access. Resetting the password in the Admin CP will use a more secure auth class.
XenForo Tutorials
XF 2 Password Reset Query
Submitted by Bi0S, 05-12-2018, 12:58 PM, Thread ID: 108167
Thread Closed