MySQLAuthenticationPlugin

MySQL authentication plugins which can be specified at the connection start, more information could be found in MySQL Reference Manual.

Name

Description

DEFAULT

Default authentication plugin, the client will firstly try to use the plugin name provided by the server.

MYSQL_CLEAR_PASSWORD

Authentication plugin which enables the client to send password to the server as cleartext without encryption.

MYSQL_NATIVE_PASSWORD

Authentication plugin which uses SHA-1 hash function to scramble the password and send it to the server.

SHA256_PASSWORD

Authentication plugin which uses SHA-256 hash function to scramble the password and send it to the server.

CACHING_SHA2_PASSWORD

Like sha256_password but enables caching on the server side for better performance and with wider applicability.

MySQLSetOption

MySQL set options which can be used by link.

Name

Description

MYSQL_OPTION_MULTI_STATEMENTS_ON

-

MYSQL_OPTION_MULTI_STATEMENTS_OFF

-

SslMode

This parameter specifies the desired security state of the connection to the server. More information can be found in MySQL Reference Manual

Name

Description

DISABLED

establish an unencrypted connection.

PREFERRED

establish an encrypted connection if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted connection cannot be established.

REQUIRED

establish an encrypted connection if the server supports encrypted connections. The connection attempt fails if an encrypted connection cannot be established.

VERIFY_CA

Like REQUIRED, but additionally verify the server Certificate Authority (CA) certificate against the configured CA certificates. The connection attempt fails if no valid matching CA certificates are found.

VERIFY_IDENTITY

Like VERIFY_CA, but additionally perform host name identity verification by checking the host name the client uses for connecting to the server against the identity in the certificate that the server sends to the client.