SAS/ACCESS and MySQL error

[Mushtaq]

Can you please provide more detail about how do you provide Environment Variables mysql to solve the problem. I using SAS eg to connect a maridb server using exactly same query like you and getting :

The libmysqlclient code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
options set=SASMYL MYWIN417;
libname mylib mysql server="xxxxxx" database=mysql user=xxx password=xxxxx port=9876;

I'll apriciate

Thanks 

Mike

[Reeza]

Do you mean the schema or some other parameter? I'm not familiar with MySQL.
https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n1lyg1d0crcejin1v7zaeteeniuu.htm&docset...

[Reeza]

Ask a colleague to try with their credentials on your machine.