I have MySQL setup on my local machine. When I try to connect to the DB server I see the following behavior and am wondering why (and does it matter)?
tDBConnection configured with "DB Version: Mysql 5"
Exception in component tDBConnection_1 (asdf)
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
If I change "DB Version: " value to MariaDB it is connected successfully.
MySQL version 8.0.11
Please have a look at this documentation:TalendHelpCenter: Supported systems, databases and business applications by Talend components
So far, MySQL 8.0 is not list on the supported databases table.
The JDBC driver we used in MySql 5 is not working with MySql 8.