参考 https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html

    1，关闭防火墙

    1. 对主服务器master关闭 192.168.245.132
    2. slave从服务器也关闭192.168.245.133
    3. /etc/init.d/iptables stop
    4. # 永久关闭
    5. chkconfig iptables off


    2，配置主服务器132

    1. vi /usr/local/mysql/my.cnf
    2. 在[mysqld]节点下配置
    3. log_bin=mysql-bin
    4. server-id=132 (为ip地址的最后一段)

    3，启动mysql服务,并连接

    1. service mysql start

    4，授权slave服务器 此处的IP为slave服务器

    1. mysql>GRANT REPLICATION SLAVE ON *.* to 'root'@'192.168.245.133' identified by 'root';
    4. ####Mysql8下执行：
    5. mysql>GRANT REPLICATION SLAVE ON  *.*  to 'root'@'%';

    5, 查看master服务器的状态

    1. show master status;

    6，配置从服务器

    1. vi /usr/local/mysql/my.cnf
    2. 在[mysqld]节点下配置
    3. log_bin=mysql-bin
    4. server-id=133 (为ip地址的最后一段)


    7,启动mysql服务并连接

    8，在从服务器中执行同步语句

    1. change master to
    2. master_host='192.168.245.132',
    3. master_user='root',
    4. master_password='root',
    5. master_log_file='第五步结果中的file字段值',
    6. master_log_pos='第五步结果中的Position'字段值;

    9,启动slave

    1. start slave;

    10 查看slave状态

    1. show slave status\G

    如果SlaveIO_State: Waiting for master
    [mysql    主从备份.rar](https://www.yuque.com/attachments/yuque/0/2021/rar/12864321/1626180960122-a7ab0099-b8ab-497e-8500-11b6cb1c60ac.rar?_lake_card=%7B%22src%22%3A%22https%3A%2F%2Fwww.yuque.com%2Fattachments%2Fyuque%2F0%2F2021%2Frar%2F12864321%2F1626180960122-a7ab0099-b8ab-497e-8500-11b6cb1c60ac.rar%22%2C%22name%22%3A%22mysql_%E4%B8%BB%E4%BB%8E%E5%A4%87%E4%BB%BD.rar%22%2C%22size%22%3A18865722%2C%22type%22%3A%22application%2Fvnd.rar%22%2C%22ext%22%3A%22rar%22%2C%22status%22%3A%22done%22%2C%22taskId%22%3A%22u9b1f61da-80b7-4730-b0af-6c7515dd140%22%2C%22taskType%22%3A%22transfer%22%2C%22id%22%3A%22gS8uR%22%2C%22card%22%3A%22file%22%7D)