1.报错:
error connecting to master 'slave@192.168.101.65:3306'
- retry-time: 60 retries: 1 message:
Authentication plugin 'caching_sha2_password' reported error:
Authentication requires secure connection.
解决办法:
CHANGE MASTER TO
MASTER_HOST='192.168.101.65',
MASTER_USER='slave',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000011',
MASTER_LOG_POS=1614,
get_master_public_key=1; --添加此行代码可解决
2.报错:
MySQL“ACCESS DENIED FOR USER‘ROOT‘@‘IP地址‘
解决办法:主库执行命令
select host, user from user
发现slave用户出现两次
user:slave 但host一次为192.168.101.1,一次为%
这里直接把其中一个删除即可解决问题(“%”指所有IP均可访问)