Datax读取Mysql8报错

报错

WARN  DBUtil - test connection of [jdbc:mysql://hadoop102:3306/datax?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC&useSSL=false] failed, for Code:[DBUtilErrorCode-10], Description:[连接数据库失败. 请检查您的 账号、密码、数据库名称、IP、Port或者向 DBA 寻求帮助(注意网络环境).].  -  具体错误信息为：java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed.
ERROR RetryUtil - Exception when calling callable, 异常Msg:DataX无法连接对应的数据库，可能原因是：1) 配置的ip/port/database/jdbc错误，无法连接。2) 配置的username/password错误，鉴权失败。请和DBA确认该数据库的连接信息是否正确。
java.lang.Exception: DataX无法连接对应的数据库，可能原因是：1) 配置的ip/port/database/jdbc错误，无法连接。2) 配置的username/password错误，鉴权失败。请和DBA确认该数据库的连接信息是否正确。
        at com.alibaba.datax.plugin.rdbms.util.DBUtil$2.call(DBUtil.java:71) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.util.DBUtil$2.call(DBUtil.java:51) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.common.util.RetryUtil$Retry.call(RetryUtil.java:164) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.common.util.RetryUtil$Retry.doRetry(RetryUtil.java:111) ~[datax-common-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.common.util.RetryUtil.executeWithRetry(RetryUtil.java:30) [datax-common-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.util.DBUtil.chooseJdbcUrl(DBUtil.java:51) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.dealJdbcAndTable(OriginalConfPretreatmentUtil.java:92) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.simplifyConf(OriginalConfPretreatmentUtil.java:59) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.doPretreatment(OriginalConfPretreatmentUtil.java:33) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Job.init(CommonRdbmsReader.java:55) [plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Job.init(MysqlReader.java:37) [mysqlreader-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:673) [datax-core-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:303) [datax-core-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:113) [datax-core-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.Engine.start(Engine.java:92) [datax-core-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.Engine.entry(Engine.java:171) [datax-core-0.0.1-SNAPSHOT.jar:na]
        at com.alibaba.datax.core.Engine.main(Engine.java:204) [datax-core-0.0.1-SNAPSHOT.jar:na]

原因

这是因为DataX默认使用的依赖是Mysql5的driver，所以需要将依赖替换掉，在datax/plugin/reader/mysqlreader/libs/目录写，读也一样
并且在指定列名的json中加上driver:"com.mysql.cj.jdbc.Driver"指定

json示例

{ 
	"job": { 
		"content": [ 
			{ 
				"reader": { 
					"name": "mysqlreader",  
					"parameter": { 
						"column": [ 
							"id", 
							"name" 
						],  
						"connection": [
                          	{ 
                                "jdbcUrl":[
                                    "jdbc:mysql://mysqlIP:3306/datax?useSSL=false"]
                                ,  
                                "table": [ 
                                    "student" 
                                ],
                                "driver":"jdbc.mysq.cj.Driver"
                            } 
                        ],  
                        "username": "root",  
                        "password": "000000" 
                    } 
                },  
                "writer": { 
                    "name": "hdfswriter",  
                    "parameter": { 
                        "column": [ 
                            { 
                                "name": "id", 
                                "type": "int" 
                            }, 
                            { 
                                "name": "name", 
                                "type": "string" 
                            } 
                        ],   
                        "defaultFS": "hdfs://IP:9000",  
                        "fieldDelimiter": "\t",  
                        "fileName": "student.txt",  
                        "fileType": "text",  
                        "path": "/datax",  
                        "writeMode": "append" 
                    } 
                } 
            } 
        ],  
        "setting": { 
            "speed": {
                "channel": "1" 
            }
        }
    }
}