docker exec -it mysqlCanal /bin/bash mysql -u root -p
1 2 3 4 5 6 7 8 9 10
CREATE USER canal IDENTIFIED BY 'canal'; GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%'; -- GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ; FLUSH PRIVILEGES;
ALTER USER 'canal'@'localhost' IDENTIFIED BY 'canal' PASSWORD EXPIRE NEVER; ALTER USER 'canal'@'localhost' IDENTIFIED WITH mysql_native_password BY 'canal'; ALTER USER 'canal'@'%' IDENTIFIED BY 'canal' PASSWORD EXPIRE NEVER; ALTER USER 'canal'@'%' IDENTIFIED WITH mysql_native_password BY 'canal'; FLUSH PRIVILEGES;
2.5 修改配置文件
2.5.1 修改canal.properties
1
vim /lankr/application/canal-1.1.15/conf/canal.properties