alibaba / canal

阿里巴巴 MySQL binlog 增量订阅&消费组件
Apache License 2.0
28.44k stars 7.6k forks source link

Canal-Admin + Canal-Server server 无法启动 版本1.1.4 #3695

Open wylwq opened 3 years ago

wylwq commented 3 years ago

register ip

canal.register.ip =

canal admin config

canal.admin.manager = 192.168.231.232:8089 canal.admin.port = 11110 canal.admin.user = admin canal.admin.passwd = 4ACFE3202A5FF5CF467898FC58AAB1D615029441

admin auto register

canal.admin.register.auto = true canal.admin.register.cluster =

admin-log报错如下 Caused by: com.alibaba.otter.canal.common.CanalException: requestGet for canal config error: Error[INSERT command denied to user 'canal'@'localhost' for table 'canal_node_server']

大佬帮忙看下

CraftLCL commented 3 years ago

你账号没有权限,先给账号授权, • GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'canal'@'%'; • -- GRANT ALL PRIVILEGES ON . TO 'canal'@'%' ; • FLUSH PRIVILEGES;