Not able to connect MYSQL Server Using SAS ACCESS TO MYSQL

Question

I am not able to connect to MYSQL server using SAS access to MYSQL.

Code:

libname mysqllib mysql user=XXXXXX password=XXXXX database=test
server="XXXX.vip.its.XXX.com";

Error:

ERROR: Error trying to establish connection: Can't connect to MySQL server on 'XXXX.vip.its.XXXX.com' (146)
ERROR: Error in the LIBNAME statement.

That sounds like you have an issue with properly identifying the server, or ports or somesuch. Perhaps you have to specify a noncustom port, or a more precise URL. I'm going to call this a duplicate, in large part simply to redirect you to a good answer for how to test things. 146 in any event I believe is a generic 'cannot connect' answer in the MySQL world, so I don't think SAS is relevant here. — Joe
possible duplicate of Unable to connect to remote MySQL Server — Joe

DomPazz DomPazz · Accepted Answer · 2013-11-11T20:29:34

So without a MySQL server to connect to and without knowing your setup, all that anyone can give you is pointers.

First, make sure you can connect to that MySQL server with those parameters. Use another client and see if that is correct.

Second, make sure that MySQL server is listening on port 3306. If not, use the PORT= option to change from the default 3306.

Third, try putting your username and password in single quotes(' ').