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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables