java.sql.SQLException: The server time zone value 'unknown' is unrecognized or represents more than one time zone. code example

Example 1: jdbc driver servertimezone configuration property

jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

Example 2: The server time zone value 'FLE' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more

SET GLOBAL time_zone = '+3:00';

Tags:

Java Example