Mysql数据库管理-[mysql] 主从同步错误Last_IO_Errno: 2061

show slave status\G
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控制台

master

ALTER USER 'model_slave'@'%' IDENTIFIED WITH mysql_native_password BY 'slave123';
FLUSH PRIVILEGES;

SLAVE

1 stop slave；

2 start slave;

show slave status\G