mysql主从报错:Last_IO_Error: Error connecting to source解决方法

森森淼淼丶

已于 2024-01-15 12:17:11 修改

阅读量6.3k

点赞数 29

CC 4.0 BY-SA版权

文章标签： oracle mysql 运维数据库 dba

于 2024-01-15 12:16:19 首次发布

本文链接：https://blog.csdn.net/weixin_61212661/article/details/135598218

报错

处理方法

1.从库停止同步

2.主库修改my.cnf 生效配置default-authentication-plugin=mysql_native_password

3.重启服务重新创建复制用户

4.重新同步

5.测试主从

报错

Last_IO_Error: Error connecting to source '[email protected]:3306'. This was attempt 3/86400, with a delay of 60 seconds between attempts. Message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.

处理方法

1.从库停止同步

mysql> stop slave;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

2.主库修改my.cnf 生效配置default-authentication-plugin=mysql_native_password

[root@ms-server1 ~]# vi /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authenti