SAS/ACCESS to MySQL via SSL

[SAS_ANON]

I am currently using Base SAS 9.3 & SAS/ACCESS to MySQL but I am having diffuclty establishing an SSL connection with a server using SAS/ACCESS.  What is the format for making a SSL connection using SAS/ACCESS or do I have to use a different method?

Thanks.

libname test mysql  user=testuser password=test database=test server='test.amazonaws.com' port=3306 BULKLOAD=YES;

[JBailey]

Wow, it looks like somebody pushed that button, and I did actual work, but not "real" work. Real work would be coding. 

Hat tip @JYus for pointing out that SAS has implemented this.

https://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=n1rfxdp6mpk61rn148n17nvhvfix.htm&doc...

Hi,

Unfortunately, connecting to MySQL from SAS/ACCESS using SSL is not supported.

If you like, you can make a feature request via the following link. I know the feature has been requested, but it doesn't hurt to pile-on just a little.

Go to http://support.sas.com. And look at the bottom left of the page.

 If you need any assistance, holler.

Best wishes,

Jeff