Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Connecting to MySQL 8.0

dhalekMay 11 2018 — edited Mar 25 2019

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

This post has been answered by dhalek on May 17 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2019
Added on May 11 2018
10 comments
74,216 views