记录Kettle中配置mysql驱动

报错1：Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
org.gjt.mm.mysql.Driver

1.确定连接数据库版本，是mysql8.0还是其他，下载对应驱动。建议直接将两个jar包移至data-integration/lib下

驱动下载地址：https://mvnrepository.com/artifact/mysql/mysql-connector-java

驱动移至lib目录下后，需要重启kettle！！

报错2：

Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
Communications link failure

The last packet successfully received from the server was 47 milliseconds ago.  The last packet sent successfully to the server was 40 milliseconds ago.
 

我是使用5.1的jar包连接mysql8.0，会报这个错，解决方案如下：

连接类型选择Generic database，才有自定义连接方式进行连接

自定义连接：jdbc:mysql://数据库ip:3306/数据库名称? useSSL=false

自定义驱动：com.mysql.cj.jdbc.Driver