笔者装完Canal后启动,发现报错:
Authentication:ErrorPacket [errorNumber=1698, fieldCount=-1, message=Access denied for user 'root'@'localhost', sqlState=28000, sqlStateMarker=#]
解决办法:
要mysql创建一个canal用户
首先检查canal的配置文件
vi instance.properties
配置的dbusername=canal
进入MYSQL执行一下语句
GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' IDENTIFIED BY 'canal' WITH GRANT OPTION;
flush privileges;