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

XF 1.4 SQL query to reset all passwords

#4
In case this is still useful to people:

Code:
UPDATE xf_user_authenticate
SET data = BINARY 'a:0:{}', scheme_class = 'XenForo_Authentication_NoPassword'
WHERE user_id = 1
 
#5
Thank you, Martin. Is there a way to reset the passwords of ALL users to a random (secure) string so that they have to reset their own password to get in? Thanks!