mysql 5.7主从库复制设置

CREATE USER ‘rep_user‘@‘%.192.168.0.106‘ IDENTIFIED BY ‘123456‘;

GRANT REPLICATION SLAVE ON *.* TO ‘rep_user‘@‘%.192.168.0.106‘;

C:\Users\Administrator>mysqldump -uroot --password --databases test01 >e:/temp/2
0170507/aa.sql
Enter password: ****

show master status;

C:\temp\mysql-5.7.13-winx64\bin>mysql -u root -p <c:/temp/aa.sql
Enter password: ****

在从库上设置复制信息

17.        mysql> CHANGE MASTER TO
18.            ->     MASTER_HOST=‘master_host_name‘,
19.            ->     MASTER_USER=‘replication_user_name‘,
20.            ->     MASTER_PASSWORD=‘replication_password‘,
21.            ->     MASTER_LOG_FILE=‘recorded_log_file_name‘,
22.            ->     MASTER_LOG_POS=recorded_log_position;


启动从库线程
START SLAVE；

使用 下面命令查看从库复制状态
show slave status;