When I set useLegacyDatetimeCode = false in the JDBC connection properties, I get this error message:
java.sql.SQLException: The server time zone value "CET" represents more than one time zone. You must configure the server driver or JDBC (via the serverTimezone configuration property) to use more time zone value if you want to use time zone support. The time zone that the CET cards are: Europe / Tirana, Europe / Andorra, Europe / Vienna, Europe / Minsk, Europe / Brussels, Europe / Sofia, Europe / Prague, Europe / Copenhagen, Europe / Tallinn, Europe / Berlin, Europe / Gibraltar, Europe / Athens, Europe / Budapest, Europe / Rome, Europe / Riga, Europe / Vaduz, Europe / Vilnius, Europe / Luxembourg, Europe / Malta, Europe / Chisinau, Europe / Tiraspol, Europe / Monaco, Europe / Amsterdam, Europe / Oslo, Europe / Warsaw, Europe / Lisbon, Europe / Kaliningrad, Europe / Madrid, Europe / Stockholm, Europe / Zurich, Europe / Kiev, Europe / Uzhhorod, Europe / Zaporizhia, Europe / S mferopol Europe / Belgrade, Africa / Algeria, Africa / Tripoli Africa / Casablanca Africa / Tunisia, Africa / Ceuta.
I understand that the message tells me, but I'm not sure what to do with it. I have no way of knowing what time zone the MySQL server is running in (this is the software that my clients install and the servers are not controlled by me).
I need to set this property to false in order to fix errors in the MySQL timezone.