mysql 主从复制
主
GRANT REPLICATION SLAVE ON . to ‘root’@‘192.168.1.9’ identified by ‘123456’;
从
CHANGE MASTER TO MASTER_HOST=‘192.168.1.225’,
MASTER_PORT=3306,
MASTER_USER=‘root’,
MASTER_PASSWORD=‘123456’,
MASTER_LOG_FILE=‘mysql-bin.000003’,
MASTER_LOG_POS=313; #后面两个参...
原创
2021-04-29 11:09:03 ·
96 阅读 ·
0 评论