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

Discussion in 'XenForo Questions and Support' started by Addsky, Oct 30, 2014.

  1. Addsky

    Addsky Member

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

    oman Well-Known Member

  3. Addsky

    Addsky Member

    Last edited: Oct 30, 2014
  4. Martin Vium

    Martin Vium Member

    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. Harness Media

    Harness Media Member

    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!
     

Share This Page