发布端连接MYSQL库异常
一、基本环境介绍
源端为 MARIADB 5.7.34 单库
二、发布库报错日志
add table test.mysql_tab1(1/6)…
error at file[mysql.c] line[38], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[mysql.c] line[110], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[db.c] line[27], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[mysql/binlog.c] line[1096], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[mysql/binlog.c] line[1178], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[log_extract.c] line[53], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
error at file[log_extract.c] line[560], ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
[ERR] update_table_list, ZCBUS-20000: mysql connect failed: Can’t connect to MySQL server on ‘192.168.0.100’ (111)
三、问题解决
1、确认发布端服务器防火墙是否关闭
systemctl status firewalld
2、查看数据库用户授权
show grants for zcbus
3、
