参考 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

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

    3，启动mysql服务,并连接

    service mysqld start

    4，在主服务器下执行：授权slave服务器 此处的IP为slave服务器

    ####Mysql5.x版本的执行
mysql>GRANT REPLICATION SLAVE ON *.* to 'root'@'192.168.245.133' identified by 'root';


####Mysql8下执行：
mysql>GRANT REPLICATION SLAVE ON  *.*  to 'root'@'%';

    5, 查看master服务器的状态

    show master status;

    6，配置从服务器

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


    7,启动mysql服务并连接

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

    change master to
master_host='192.168.200.133',
master_user='root',
master_password='root',
master_log_file='第五步结果中的file字段值',
master_log_pos=第五步结果中的Position字段值;

    9,启动slave

    start slave;

    10 查看slave状态

    show slave status\G

    如果SlaveIO_State: Waiting for master
    [mysql    主从备份.rar](https://www.yuque.com/attachments/yuque/0/2018/rar/96947/1535014578113-3ea2d767-c369-4434-b46c-aab5eaf2ac9a.rar?_lake_card=%7B%22src%22%3A%22https%3A%2F%2Fwww.yuque.com%2Fattachments%2Fyuque%2F0%2F2018%2Frar%2F96947%2F1535014578113-3ea2d767-c369-4434-b46c-aab5eaf2ac9a.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%22source%22%3A%22%22%2C%22status%22%3A%22done%22%2C%22mode%22%3A%22title%22%2C%22download%22%3Atrue%2C%22id%22%3A%22gS8uR%22%2C%22card%22%3A%22file%22%7D)