kettle 连接 mysql8.0 报错的解决办法 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.

时间:2023-03-08 22:23:47

1、下载 mysql8.0 驱动放到 如下目录中

mysql8.0以上的驱动下载链接:mysql-connet-8.0.13

kettle 连接 mysql8.0 报错的解决办法  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.

2、配置你连接的数据库

找到如下文件打开编辑

kettle 连接 mysql8.0 报错的解决办法  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.

连接信息:下面是我本地的配置

MYSQL8_DB/type=javax.sql.DataSource
MYSQL8_DB/driver=com.mysql.cj.jdbc.Driver
MYSQL8_DB/url=jdbc:mysql://localhost:3306/junsheng?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT
MYSQL8_DB/user=root
MYSQL8_DB/password=123456

kettle 连接 mysql8.0 报错的解决办法  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.

3、打开kettle进行连接

kettle 连接 mysql8.0 报错的解决办法  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.

4、检测是否连接成功

kettle 连接 mysql8.0 报错的解决办法  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.

出现正确连接到数据库就说明连接成功了。

5、写个表查询看看数据

kettle 连接 mysql8.0 报错的解决办法  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.