How to connect to MySql 8.0 database using Eclipse Database Management Perspective

Question

I wanted to connect to local MySql 8.0 database using Eclipse database tools. But while setting up new database connection profile, I could not find Driver Template for MySql 8.0 . The list only contains Template profile upto MySql JDBC Driver 5.1 . So How can newer version of MySql like 8.0 in my case can be connected using eclipse DTP tools

Answer 1

You need to select version 5.1 from the list. MySQL JDBC driver version 5.1 (i.e. Connector/J 5.1) is compatible with MySQL 8.0. Given below is an excerpt from https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-versions.html:

Connector/J 5.1 is a Type 4 pure Java JDBC driver, which conforms to the JDBC 3.0, 4.0, 4.1, and 4.2 specifications. It provides compatibility with all the functionality of MySQL, including 5.6, 5.7 and 8.0.

Answer 2

I had the same issue and I did the followings,

select the MYSQL JDBC Driver 5.1 and change the Driver name to unique name as below,

Next I removed the existing jar and include the correct MYSQL jar file in the jar list,

Important - Remove the 5.1 jar else it will give you and error

finally setup the Database connection database name, user name and password

And Now Click OK!!!