SSL_CERT= LIBNAME Statement Option

Specifies the full path name to the certificate 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_CA= 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

SSL_CERT="path-name"

Syntax Description

path-name

specifies the full path name to the certificate 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 certificate file identifies the server public key certificate. A certificate file is configured as part of configuring your MySQL server to use secure connections. The certificate file must be specified in order to establish a secure connection to the server. For more information about configuring MySQL and creating certificates, see the security information in your MySQL Server documentation.

Last updated: February 3, 2026