/

SQL Snippets

SQL Snippets

Owned by Michael Bodkin (Unlicensed)

Last updated: May 03, 2023

1 min read

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'

Related content

OAUTH 2 Access Code Auth Flow for Rest APIs

OAUTH 2 Access Code Auth Flow for Rest APIs

Read with this

Sunwave Health Digest Authentication

Sunwave Health Digest Authentication

More like this

ePrescribe - I Forgot My Password / I Lost My Authentication Token

ePrescribe - I Forgot My Password / I Lost My Authentication Token

Sunwave Knowledge Base

More like this