MySQL data source¶

You can use this provider to connect to your MySQL database.

Configuration manual¶

Connection settings¶

These settings relate to the connection to your MySQL database server.

Server¶

Enter the fully qualified domain name (FQDN) or IP address of your MySQL server.

Examples:

• mysql.mycompany.com
• 192.168.1.100
• localhost

Port¶

Specify the port number your MySQL server is listening to. The default MySQL port is 3306. Only change this if your MySQL server is configured to use a different port.

Database¶

Enter the name of the database you want to connect to. The database must exist on the server before you can connect to it.

Connection Timeout¶

Specify the time (in seconds) to wait when establishing a connection to the MySQL server before timing out. Increase this value if you experience connection timeouts due to network latency or slow server response.

Command Timeout¶

Specify the time (in seconds) to wait for a query to complete before timing out. Increase this value if you have long-running queries or large data extractions.

Below settings are related to authentication with your MySQL server.

User settings¶

SSL¶

Select the SSL/TLS encryption mode for your connection.

• Disabled: Do not use SSL. Connection is unencrypted.
• Preferred: (Default) | Use SSL if the server supports it, otherwise falls back to unencrypted.
• Required: Always use SSL. Connection fails if server does not support SSL. Does not validate CA or hostname.
• Verify CA: Always use SSL. Validates the Certificate Authority but tolerates hostname mismatch.