在windows中 连接linux的mysql 连接失败会报如下错误
解决方案
1,在linux中连接mysql后创建新用户,并授权所有主机都可连接
CREATE USER 'canal'@'%' IDENTIFIED BY '密码包含大小写和符号数字';
GRANT SHOW VIEW, SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
FLUSH PRIVILEGES
CREATE USER 'canal'@'%' IDENTIFIED BY '密码包含大小写和符号数字';
GRANT SHOW VIEW, SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
FLUSH PRIVILEGES