Forum Stats

  • 3,838,062 Users
  • 2,262,325 Discussions


Connecting to MySQL 8.0

dhalek Member Posts: 189 Bronze Badge
edited Mar 25, 2019 11:26AM in SQL Developer

Hello out there,

I set up a new MySQL Server 8.0.11. To support the new password security features I use mysql-connector-java-8.0.11.jar in SQL Developer as JDBC driver for MySQL.

Trying to set up a new connection to this server I get this error:

The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.

Well, that is a solvable problem. I edited my connections.xml and replaced convertToNull with CONVERT_TO_NULL.

So then I'm propted for a password and get this:

The server time zone value 'Mitteleuropäische Sommerzeit' 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.

Now I'm stuck. What must bee done to get around this one? I did not set any timezone at server side. As I'm understanding the timezone on the server is SYSTEM by default. The server seems to return timezone description (which means CEST or UTC+2 btw.) instead of some usable code.

Using the old JDBC connector I got errors saying something about being unable to load the module for caching_sha2_password.

Any ideas?



106a2041-f097-47d6-95c8-bf85c57658baLisa Franscoviaka70b24fb-6e3e-459f-b788-b341275ccda034af4b32-d908-4c0a-a6b2-432bdad53142

Best Answer

  • dhalek
    dhalek Member Posts: 189 Bronze Badge
    edited May 17, 2018 10:38AM Answer ✓

    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.

    Kind regards,



This discussion has been closed.