[mysql] 主从同步错误Last_IO_Errno: 2061
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master ‘root@192.168.0.10:3306’ – retry-time: 60 retries: 1 message: Authentication plugin ‘caching_sha2_password’ reported error: Authentication requires secure connection.
1.问题现象
启动slave，查看slave状态，发现报错。
有个错误IO线程在连接中, 还有一个问题就是：
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master ‘root@192.168.0.10:3306’ – retry-time: 60 retries: 1 message: Authentication plugin ‘caching_sha2_password’ reported error: Authentication requires secure connection.
2.原因
加密方式和解密方式不一致，修改密码加密规则.进入mysql控制台
ALTER USER 'model_slave'@'%' IDENTIFIED WITH mysql_native_password BY 'slave123';
FLUSH PRIVILEGES;
重启slave。
3.这时抛出了另一个问题
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the –replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
4.解决方法：重启mysql服务
service mysql restart
5.进入mysql，重启slave
mysql -u root -p
start slave
show slave status\G;
成功！