kettle 连接 mysql 8.0报错,显示无法连接到数据库服务
错误连接数据库 [11] : org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Could not create connection to database server. org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database Error connecting to database: (using class org.gjt.mm.mysql.Driver) Could not create connection to database server. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.现状,url,库名,表名都没有问题
原因:因为没有安装jar包。
解决:kettle\data-integration\lib包下面加装mysql连接的jar包
重新连接mysql,测试显示成功
参考和jar包来自:https://www.bilibili.com/video/BV1244y1K7oz/?spm_id_from=333.337.search-card.all.click