今天安装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;