SQL Snippets

SETUP USER

Set the password to “santiago” and don’t have it expire.

mb2_user 
 SET PASSWORD = 'Sfqq3kk76La2Fk7mf35NEBgSpd2pcNbKaT3ai4z4Lks=',
 tm_password = '{SHA}Sfqq3kk76La2Fk7mf35NEBgSpd2pcNbKaT3ai4z4Lks=',
 password_changed_on = now() 
WHERE EMAIL = 'michael.bodkin@sunwavehealth.com' AND LAST_NAME = 'Bodkin';COMMIT;
UPDATE sw_user_clinic
  SET ext_email_server = 'smtp.gmail.com' 
WHERE user_email = 'michael.bodkin@sunwavehealth.com';
COMMIT;

See Users

SELECT * FROM mb2_user;

Clinic User

select * from sw_user_clinic where user_email = 'michael.bodkin@sunwavehealth.com'