Version : doris-2.1.8-rc01
创建外部表
CREATE CATALOG EX_tiantian_MySQL1_zb_sx_cn_ccdata
PROPERTIES (
"user" = "shucang",
"type" = "jdbc",
"password" = "*XXX",
"jdbc_url" = "jdbc:mysql://MySQL1.zb-sx.cn:33060/ccdata?useUnicode=true&characterEncoding=utf8&useSSL=false&yearIsDateType=false&tinyInt1isBit=false&rewriteBatchedStatements=true&characterEncoding=utf-8",
"driver_url" = "https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com/jdbc_driver/mysql-connector-java-8.0.25.jar",
"driver_class" = "com.mysql.cj.jdbc.Driver",
"checksum" = "fdf55dcef04b09f2eaf42b75e61ccc9a"
);
数据库:MySQL5.6
从Doris连接会反复提示:ERROR 1129 (HY000): Host 'xxx.xxx.x.60' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
在MySQL5.6上执行flush hosts,Doris就能连接到mysql了
半天后又会连不上
之前曾有过创建catalog时候密码写错的情况,后来把对应的catalog删除,重新创建了,但是现在还是会出现以上情况。
哪位大佬遇到过。有多个MySQL,只有这个出现过密码写错的情况,感觉是之前密码写错误的时候,通过drop catalog 没有删除干净,还在用错误密码请求连接MySQL服务端。