...
Code Block |
---|
&enabledTLSProtocols=TLSv1,TLSv1.1,TLSv1.2 |
Set time zone
When data is imported from MySQL, the connector performs time zone adjustments to imported Datetime values.
Tip | ||||
---|---|---|---|---|
Tip: By default, the MySQL driver adjusts the imported data to be represented in the time zone into which it is being read. If you are located in GMT -08:00, all data is rendered that your
|
These adjustments are performed in either of the following cases:
- The MySQL server is configured with a canonical time zone that is recognizable by Java (for example, Europe/Paris, Etc/GMT-5, UTC, etc.).
- The server's time zone is overridden by setting the Connector/J connection property serverTimezone.
In the latter case, you can specify the override time zone to apply as part of the connection string:
Code Block |
---|
&serverTimezone=Europe/Paris |
The following value sets the time zone of imported data to be UTC:
Code Block |
---|
&serverTimezone=UTC |
For more information on this behavior, see https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-other-changes.html.
Driver Information
This connection uses the following driver:
...
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.
| ||
Set the following option in the connect string options:
| |||
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:
| ||
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.
...