Flink MYSQL CDC异常处理

1

Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

原因

账号需要RELOAD这个服务管理员权限

解决

grant reload on *.* to 'user_name'@'%';

2

Cannot read the binlog filename and position via ‘SHOW MASTER STATUS’

问题

没有开启binlog

解决

配置文件

[mysqld]
log-bin=mysql-bin
server-id=1

3

Encountered change event for table xxx whose schema isn’t know

问题

没有开启SELECT,SHOW DATABASES权限

解决

grant select, show databases on *.* to 'user_name'@'%';