mysql8.0 io线程不同步grant replication slave on *.* to ‘dc‘@‘%‘ identified by ‘123456‘； 报错

今天安装mysql8之后，想要做主从同步，使用以前的命令授权失败。

CREATE USER 'dc'@'%' IDENTIFIED BY '123456';
alter user 'dc'@'%' identified with mysql_native_password by '123456';

原因是mysql8之后需要先创建用户，之后才能授权，
可以试试这个密令：

CREATE USER dc IDENTIFIED BY '123456';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'dc'@'%';
GRANT ALL PRIVILEGES ON . TO 'dc'@'%' ;
FLUSH PRIVILEGES;