Can't connect to mySQL 8.0 using Toplink and mysql connector version 8.0.11

I'm upgrading from MySQL 5.1 to MySQL 8.0.  I have a java project that uses Toplink to connect to the database.  I've updated the jdbc drivers but when I try to connect I get this error "Public Key Retreival is not allowed".  I've set UseSSL to false but I still can't connect.  I'm assuming there must be some new parameters that I also need to set up , but I don't know what they are or where to look for them.
LVL 1
Doug PoulinCTOAsked:
Who is Participating?
 
Doug PoulinCTOAuthor Commented:
there is a new option.  It's (surprise, surprise) allowPublicKeyRetrieval=true
That solved my problem.
0
 
CEHJCommented:
You might try

jdbc:mysql://localhost/databasehost?verifyServerCertificate?=false&useSSL=false 

Open in new window


but It's conceivable that Toplink does not yet support 8.0. (Check the docs)
0
 
CEHJCommented:
Good :) Feel free to close the question by accepting your last comment
0
 
Doug PoulinCTOAuthor Commented:
The solution was kind of obvious once I found the right documentation.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.