mysql主从复制docker部署

拉取mysql8.0镜像启动容器

主服务器
show master status;
CREATE USER 'slave'@'%' IDENTIFIED BY '000000';
ALTER USER 'slave'@'%' IDENTIFIED WITH mysql_native_password BY '000000';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'slave'@'%';
FLUSH PRIVILEGES;

从服务器
show slave status;
change master to master_host='172.18.83.17', master_user='slave', master_password='000000', master_port=3308, master_log_file='master-bin.000003', master_log_pos=1676, master_connect_retry=30;  
start slave;
show slave status;