windows安装两个mysql_qq_30320541的博客-CSDN博客_windows安装两个mysql
假设现在已经安装好两个mysql:
需要在master上执行以下脚本:
create user 'slave'@'192.168.122.1' IDENTIFIED by 'slave';
grant replication slave on *.* to 'slave'@'192.168.122.1';
flush PRIVILEGES;
查看命令:
show master status;
show binlog events in 'mysql-bin.000002';
然后在slave上执行:
CHANGE MASTER TO MASTER_HOST='192.168.122.1', MASTER_PORT=3310, MASTER_USER='slave',MASTER_PASSWORD='slave', MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=1191;
然后执行:
start slave;
查看slave状态:
show slave status;
要停止主从同步命令:
stop slave;