As the error message says, you probably have to set the serverTimezone manually:
Override detection/mapping of time zone. Used when time zone from server doesn't map to Java time zone
Since version: 3.0.2
1 person found this helpful
From mysql workbench run the following sql statements:
SET @@global.time_zone = '+00:00';
SET @@session.time_zone = '+00:00';
with the following sql statements check if the values were set:
SELECT @@global.time_zone, @@session.time_zone;
that solved the problem.
Thank you, that may solve my problem, but I hat to revert to an earlier version of MySQL because other software hat similar problems connecting to the brand new version.
So I cannot test your solution right now.
***Moderator note (Timo): User, this is an English language space. Post your questions and answers in English language, please!***
I solved it in this way by adding the server time zone to the connection string like this
_________________________________________ ORIGINAL MESSAGE
Yo lo soluciones de esta forma agregandole el server time zone a la cadena de conexion asi:
In SQL Developer where should I specify the connection string, In SQL Developer I just click on the + button in the Connections panel and connection dialog box opens, fill in the user name and password, hostname, port and the database and click connect. There is no option to enter the connection string?
Thank you, this worked for me.
For SQL Developer, there is a connection hack that worked for me when there was a timezone mismatch between the client and server. (In my case I could not modify the server parameters.) The hack exploits the fact that the Port field is just appended to the connection URL as a string. So something like this works:
I needed the dummyparam= at the end to protect against URL format errors when the trailing slash gets appended.
Thank you - this worked.
I am using ignition a SCADA software from Inductive Automation and I solve this problem by adding "serverTimezone=UTC;" to the connecction properties as you suggest