Connect to SingleStore with a MySQL LIBNAME Statement

Note: Support for accessing SingleStore via a MySQL LIBNAME statement has been deprecated as of SAS 9.4M9.

When you connect to a SingleStore server, you must specify the appropriate authentication plug-in in a MySQL LIBNAME statement. This requires that you set DEFAULT_AUTH_PLUGIN=mysql_native_password in the LIBNAME statement. For more information, see the DEFAULT_AUTH_PLUGIN= LIBNAME option.

Last updated: February 3, 2026