...
Set the password to “santiago” and don’t have it expire.
| Code Block |
|---|
|
UPDATE 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
| Code Block |
|---|
|
SELECT * FROM mb2_user; |
Clinic User
| Code Block |
|---|
|
select * from sw_user_clinic where user_email = 'michael.bodkin@sunwavehealth.com' |