搭建otter水獭-Canal访问数据库权限问题

异常信息

pid:1 nid:1 exception:canal:test_canal:com.alibaba.otter.canal.parse.exception.CanalParseException: command : 'show master status' has an error! pls check. you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation

解决

创建用户

mysql> CREATE USER canal IDENTIFIED BY 'MYPASSSWORD'; 

开启操作权限

mysql> GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';  
mysql> FLUSH PRIVILEGES;

如果用户无GRANT权限，参考：https://blog.csdn.net/weixin_43165534/article/details/106427819

修改服务端配置

vi /etc/my.cnf

追加配置信息

...

log-bin=mysql-bin
binlog-format=ROW
server_id=1

重启mysql

service mysqld restart