# MySQL

### Connecting to MySQL <a href="#connecting-to-mysql" id="connecting-to-mysql"></a>

The following connection properties are required in order to connect to data.

* Server: The host name or IP of the server hosting the MySQL database.
* Port: The port of the server hosting the MySQL database.

You can also optionally set the following:

* Database: The default database to connect to when connecting to the MySQL Server. If this is not set, tables from all databases will be returned.

#### Connect Using Standard Authentication <a href="#connect-using-standard-authentication" id="connect-using-standard-authentication"></a>

To authenticate using standard authentication, set the following:

* User: The user which will be used to authenticate with the MySQL server.
* Password: The password which will be used to authenticate with the MySQL server.

#### Connect Using Integrated Security <a href="#connect-using-integrated-security" id="connect-using-integrated-security"></a>

As an alternative to providing the standard username and password, you can set IntegratedSecurity to **True** to authenticate trusted users to the server via Windows Authentication.

#### Connect Using SSL Authentication <a href="#connect-using-ssl-authentication" id="connect-using-ssl-authentication"></a>

You can leverage SSL authentication to connect to MySQL data via a secure session. Configure the following connection properties to connect to data:

* SSLClientCert: Set this to the name of the certificate store for the client certificate. Used in the case of 2-way SSL, where truststore and keystore are kept on both the client and server machines.
* SSLClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.
* SSLClientCertSubject: The subject of the TLS/SSL client certificate. Used to locate the certificate in the store.
* SSLClientCertType:; The certificate type of the client store.
* SSLServerCert: The certificate to be accepted from the server.

#### Connect Using SSH Authentication <a href="#connect-using-ssh-authentication" id="connect-using-ssh-authentication"></a>

Using SSH, you can securely login to a remote machine. To access MySQL data via SSH, configure the following connection properties:

* SSHClientCert: Set this to the name of the certificate store for the client certificate.
* SSHClientCertPassword: If a client certificate store is password-protected, set this value to the store's password.
* SSHClientCertSubject: The subject of the TLS/SSL client certificate. Used to locate the certificate in the store.
* SSHClientCertType: The certificate type of the client store.
* SSHPassword: The password that you use to authenticate with the SSH server.
* SSHPort: The port used for SSH operations.
* SSHServer: The SSH authentication server you are trying to authenticate against.
* SSHServerFingerPrint: The SSH Server fingerprint used for verification of the host you are connecting to.
* SSHUser: Set this to the username that you use to authenticate with the SSH server.