Set time zone
When data is imported from MySQL, the connector performs time zone adjustments to imported Datetime values.
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:
The following value sets the time zone of imported data to be UTC:
For more information on this behavior, see https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-other-changes.html.
This connection uses the following driver:
|D s api refdoclink|
|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.