#进入容器
sudo docker exec -it mysql_write_1 bash
#登录mysql
mysql -u root -p123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;#修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';#修改密码加密策略
flush privileges;#刷新权限
quit
exit
#进入容器
sudo docker exec -it mysql_read_1 bash
#登录mysql
mysql -u root -p123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;#修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';#修改密码加密策略
flush privileges;#刷新权限
quit
exit
#从服务器配置主从关系
change master to master_host='172.24.240.1',master_port=33061,master_user='root',master_password='123456', master_log_file='master-bin.000001',master_log_pos=154;#保存start slave;#查看是否成功
show slave status \G;