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