Which DB server are you trying to connect? MySQL 5 OR MySQL 8? On which talend build version you got this issue?
So far, Talend has added support for Mysql 8 in the db of studio as from the 7.1.1 version.
i am using MySQL version 8
and i am using talend 7.0
Did talend 7.0 supports MySQL 8.?
MySQL 8 is not list on the supported table for v 7.0.
For more information, please refer to this online documentation:TalendHelpCenter: Supported systems, databases and business applications by Talend components
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema