mysql主从配置

主机
1.mysql > SET GLOBAL server_id=1;
2.show master status （抄下MASTER_LOG_FILE，MASTER_LOG_POS）
3.GRANT REPLICATION SLAVE,FILE ON . TO ‘root’@‘192.168.50.248’ IDENTIFIED BY ‘1122wwo’;
4.flush privileges;

副机
1.mysql > SET GLOBAL server_id=2;
2.mysql >CHANGE MASTER TO MASTER_HOST=‘192.168.50.180’,MASTER_PORT=3306,MASTER_USER=‘root’,MASTER_PASSWORD=‘1122wwo’,MASTER_LOG_FILE=‘master-bin.000009’,MASTER_LOG_POS=38636
3.mysql> start slave;
4.mysql>show slave status \G; (查看slave状态)
5.GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%'IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
6.flush privileges;
7.service mysql restart

谢谢打赏