mysql 8.0执行报错:
mysql> GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%' IDENTIFIED BY 'canal' ;
替换执行:
mysql> CREATE USER canal IDENTIFIED BY 'canal';
mysql> GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;
mysql> FLUSH PRIVILEGES;
更新密码:
select host, user, authentication_string, plugin from user;
#更新一下用户密码
#如果host 是 localhost使用:
ALTER USER 'canal'@'localhost' IDENTIFIED WITH mysql_native_password BY 'canal';#如果host 是 % 使用:
ALTER USER 'canal'@'%' IDENTIFIED WITH mysql_native_password BY 'canal';
#刷新权限
FLUSH PRIVILEGES;