XF 1.4 SQL query to reset all passwords

[Addsky]

Hi, i need make SQL query to reset passwords at all users. Can u help pls?

 

[oman]

Hi, i need make SQL query to reset passwords at all users. Can u help pls?

https://xenforo.com/community/resources/password-reset-query.368/

 

[Addsky]

https://xenforo.com/community/resources/password-reset-query.368/

Ty, but here i must set new password for all users, but i need no password for all. How i can make it?

And this post was 2012 year, is it work on xenforo 1.4?

 

[Martin Vium]

In case this is still useful to people:

UPDATE xf_user_authenticate
SET data = BINARY 'a:0:{}', scheme_class = 'XenForo_Authentication_NoPassword'
WHERE user_id = 1

 

[Harness Media]

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!

 

[rosal]

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!

I didn't find a solution for this yet, to.

Did you found a solution?

Regards