Home

Welcome to the ChurchCRM wiki!

Mysql Client direct DB intervention

Change password for a user

ChurchCRM currently uses SHA256 hash of the plaintext password salted with the ID of the user record. Securing the method of password hashing is discussed in https://github.com/ChurchCRM/CRM/issues/2342

UPDATE `user_usr` SET 
    `usr_Password` = SHA2(CONCAT("SECRET_PASSWORD", usr_per_ID),256)
  , `usr_NeedPasswordChange` = 0 
WHERE usr_per_ID = 1 
  AND usr_UserName = 'Admin';