DEFAULT_AUTH_PLUGIN= LIBNAME Statement Option

Specifies the authentication plugin to use for a connection to a MySQL compatible data source.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Access
Default: caching_sha2_password (for MySQL 8 and higher client)
Requirement: When you use a MySQL 8 client to connect to SingleStore, specify DEFAULT_AUTH_PLUGIN=mysql_native_password.
Data source: MySQL

Table of Contents

Syntax

Required Argument

caching_sha2_password | mysql_native_password

specifies the authentication plugin to use for a connection to a MySQL compatible data source.

Last updated: February 3, 2026