Issue
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
Solution
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.
Answered By - Arvind Kumar Avinash
Answer Checked By - David Marino (JavaFixing Volunteer)
