Example SAS libname statement to connect to a local MySQL database:
libname mys mysql user=your-username password=your-password database=your-database-name server='127.0.0.1' port=3306;
The above would also work with
server='localhost'
To connect to a non-local database, simply change the IP address or server name of the server. Please note these statements will only work if the SAS/ACCESS interface is installed.
libname mys mysql user=your-username password=your-password database=your-database-name server='127.0.0.1' port=3306;
The above would also work with
server='localhost'
To connect to a non-local database, simply change the IP address or server name of the server. Please note these statements will only work if the SAS/ACCESS interface is installed.
