一文帮你搞定mysql主从复制

$MYSQL$主从复制

首先要修改$mysql$数据库的配置文件/etc/my.cnf

//主数据库
log-bin=mysql-bin   #启用二进制日志
server-id=1         #设置主服务器唯一id
//从数据库
server-id=2         #设置从服务器唯一id

然后要在数据库中执行以下命令

//主数据库
CREATE USER 'xiaoke'@'%' IDENTIFIED with caching_sha2_password BY '123456'; 
GRANT Replication Slave ON *.* TO 'xiaoke'@'%' ;
flush privileges;  
select `user`,`host` from `user`;
SHOW master STATUS;
//从数据库
CHANGE MASTER TO 
MASTER_HOST='172.17.0.2',
MASTER_PORT=3306,
MASTER_USER='xiaoke',
MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=157,
GET_MASTER_PUBLIC_KEY=1;
STOP SLAVE;
START SLAVE;
SHOW SLAVE STATUS;