Home

Welcome to the ChurchCRM wiki!

Mysql Client direct DB intervention

Change password for a user

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';