topic MYSQL Database connection from SAS Studio. in SAS Programming

MYSQL Database connection from SAS Studio.

akshayn951 — Tue, 06 Oct 2020 09:29:32 GMT

Hi,

I want to connect with the MYSQL database from SAS Studio. I got the following Libname option:

libname mysqllib mysql user=myusr1 password=mypwd1 database=mysqldb server=mysrv1 port=9876;

at the SAS documentation but I need some other way to connect so I can avoid these passwords and other credentials to show in SAS code.

Let me know if there is a way to do this in Base SAS Studio.

Re: MYSQL Database connection from SAS Studio.

JosvanderVelden — Tue, 06 Oct 2020 16:16:56 GMT

Have you seen this blog: https://blogs.sas.com/content/sgf/2017/04/13/one-deadly-sin-sas-programmers-should-stop-committing/

Re: MYSQL Database connection from SAS Studio.

akshayn951 — Wed, 07 Oct 2020 11:26:02 GMT

Yes I did read this blog. and currently checking for the AUTHDOMAIN= SAS/ACCESS option in SAS. But I'm not able to clearly understand How AUTHDOMAIN= works.
Can you give me a brief summary of how AUTHDOMAIN= works ?

Thanks.

Re: MYSQL Database connection from SAS Studio.

JosvanderVelden — Mon, 19 Oct 2020 08:57:34 GMT

Does this help?
https://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/gear-passwords.pdf