SSL_CA= LIBNAME Statement Option

Specifies the full path name to the certificate authority file.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Access
Default: none
Restriction: This option is not supported on AIX or HP-UX platforms.
Data source: MySQL
See: SSL_CERT= LIBNAME option, SSL_CIPHER= LIBNAME option, SSL_KEY= LIBNAME option
Example: 
libname db mysql user=myuser database=myDB server=myServer port=3306 
                   password=myPwd dbconinit="SET names utf8" PRESERVE_COL_NAMES=YES 
                   PRESERVE_TAB_NAMES=YES 
                   ssl_key="/u/myuser/mysql/newcerts/client-key.pem" 
                   ssl_cert="/u/myuser/mysql/newcerts/client-cert.pem" 
                   ssl_ca="/u/myuser/mysql/newcerts/ca-cert.pem"
                   ssl_cipher="DHE-RSA-AES256-SHA" ;

Table of Contents

Syntax

Syntax Description

path-and-file-name

specifies the full path, including file name, to the certificate authority (CA) file to use to establish a secure connection to the MySQL server.

Details

Certificate files enable MySQL to support secure connections using TLS encryption and validation. A CA file contains a list of trusted certificate authorities. A CA file is configured as part of configuring your MySQL server to use secure connections. The CA file must be specified in order to establish a secure connection to the server. For more information about configuring MySQL and creating CA files, see the security information in your MySQL Server documentation.

Last updated: February 3, 2026