记录MySQL8主从授权

#主机授权
create user slave@'%' identified by '123456';
GRANT ALL PRIVILEGES ON *.* TO 'rep'@'%'WITH GRANT OPTION;
flush privileges;
show master status;

#从机搭建
#从机  master_host: 主机名
#master_port：主机端口
#master_user: 主从复制账户slave
#master_password：slave密码
#master_log_file：
#master_log_pos：

change master to master_host="172.16.20.14",master_port=3307,master_user="slave",master_password="123456",master_log_file="mysql-bin.000008",master_log_pos=634;
start slave;
show slave status