...
| Excerpt |
|---|
You can create connections to one or more databases from databases from the . For more information on MySQL, see https://www.mysql.com/. |
If you are connecting the
to to any relational source of data, such as Redshift or Oracle, you must add the
to your whitelist for those resources. See
Whitelist Platform Service.
...
| Property | Description |
|---|
| Host | Enter your fully qualified hostname. Example:
| Code Block |
|---|
mysql-server.example.net |
|
| Port | Set this value to 3306. |
| Connect String Options | Insert any additional connection parameters, if needed. See below. |
| User Name | Username to use to connect to the database. |
| Password | Password associated with the above username. |
| Test Connection | After you have defined the connection credentials type, credentials, and connection string, you can validate those credentials. |
| Advanced options: Default Column Data Type Inference | Set to disabled to prevent the platform from applying its own type inference to each column on import. The default value is enabled. |
| Advanced options: Enable SSH Tunneling | If available, the SSH tunneling options allow you to configure SSH tunneling authentication between the and and your database. | Info |
|---|
NOTE: SSH tunneling is available on a per-connection basis. It may not be available for all connections. |
For more information, see Configure SSH Tunnel Connectivity. |
| Connection Name | Display name of the connection |
| Connection Description | Description of the connection, which appears in the application. |
...
The properties that you provide are inserted into the following URL, which connects connects the
to the connection:
| Code Block |
|---|
jdbc:mysql://<host>:<port>/<database><connect-string-options> |
...
| D s api refdoclink |
|---|
#operation/createConnection |
Troubleshooting
| Error message | Description |
|---|
| 1042 - ER_BAD_HOST_ERROR | Unable to connect to host. Please verify the host and port values. |
| 1045 - ER_ACCESS_DENIED_ERROR | Credentials failed to connect. Please verify your credentials. | Tip |
|---|
Tip: Click the Test Connection button to verify that your credentials are working properly. |
|
| Error: zero date value prohibited | Set the following option in the connect string options: | Code Block |
|---|
zeroDateTimeBehavior=convertToNull |
|
| Prepared statement needs to be re-prepared. | Database Cursor is not compatible with PREPARED statements in MySQL. The fix is to set the following in the Connect String Options: | Code Block |
|---|
useCursorFetch=false |
|
| SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate) | SSL ciphers need to be enabled. For more information, see "Enable TLS (SSL)" above. |
For more information on error messages for this connection type, see https://dev.mysql.com/doc/refman/8.0/en/error-handling.html.
...
