由于改了root密码,导致备库同步异常
备库同步报错
MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
mysql>use performance_schema;
mysql>select * from host_cache\G; #对比错误量
① 进入Mysql数据库查看max_connection_errors: show variables like '%max_connection_errors%';
② 修改max_connection_errors的数量为1000: set global max_connect_errors = 1000;
③ 查看是否修改成功:show variables like '%max_connection_errors%';
发现刷新修改参数以后报错换了,变成如下:】
Last_IO_Error: error connecting to master 'repl@127.0.0.1:3316' - retry-time: 60 retries: 2 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
可是客户操作,没有修改过密码
用正确的密码成功登录主库一次,备库回复正常