SSL_CIPHER= LIBNAME Statement Option

Specifies a list of permissible ciphers to use for TLS encryption.

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_CERT= 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_CIPHER="cipher-list"

Syntax Description

cipher-list

specifies a list of ciphers that are permitted to be used for TLS encryption.

Details

Each secure connection to the MySQL Server uses an encryption cipher. The SSL_CIPHER= option provides a list of ciphers that are permitted on any particular secure connection. For more information about using MySQL Server ciphers, see the security information in your MySQL Server documentation.

Last updated: February 3, 2026