1.主库操作 1)配置主库 [root@db01 ~]# vim /etc/my.cnf [mysqld] server_id=1 log_bin=mysql-bin 2)授权一个主从用户 mysql> grant replication slave on *.* to rep@'172.16.1.%' identified by '123'; #grant replication slave 是一个全局授权,