canal同步mysql出现权限问题
1.mysql的binlog日志需要是ROW
show variables like '$binlog_format%';
2.binlog是否开启
show variables like'%log_bin%';
3.用户是否有权限
show master status;
否,授权给Canal用户
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
FLUSH PRIVILEGES;