9 Replies Latest reply on Mar 25, 2019 3:26 PM by a70b24fb-6e3e-459f-b788-b341275ccda0

    Connecting to MySQL 8.0

    dhalek

      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?

       

      Regards,

      dhalek