I am trying to connect to a MySQL database using Oracle SQL Developer, but I get this error: Status: fail, test failed:
Estado: Fallo:Fallo de la prueba: The server time zone value 'PDT' 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 specifc time zone value if you want to utilize time zone support.
According to some solutions I should use a connection string such as the following, to override the server TimeZone definition.
(In my test it says
localhost but I am doing an SSH tunnel to a remote server.)
There is no way to add extra parameters such as
serverTimezone from the configuration box.
Some other solutions propose to create a map of timezones (v.g. mapping
I cannot find a Java control. It is supposed to be integrated within Oracle SQL Developer. I just cannot find any place I can add any extra configuration. I don't have administrative privileges in the server. I might change to some other MySQL client (I can actually work fine with PHPMyAdmin), but I also need to test on Oracle Servers.