mysql8.0 创建用户 GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO ‘canal‘@‘%‘ IDENTIFIE 报错

 

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;