mysql主从同步

https://blog.csdn.net/weixin_45247019/article/details/124748512

cd /mydata/mysql/conf
#修改文件
vi my.cnf

[mysqld]
# 开启二进制日志并指定日志名前缀
log-bin=mysql-bin
# 设置唯一库ID
server-id=1

service mysql restart

# 登录mysql
mysql -u root -p
# 创建用户repl
mysql> CREATE USER 'replymeee'@'%' IDENTIFIED WITH mysql_native_password BY 'replymeee';
# 授予用户repl从库相关权限
mysql> GRANT REPLICATION SLAVE ON *.* TO 'replymeee'@'%';
# 刷新权限
mysql> flush privileges;

mysql> SHOW MASTER STATUS;

cd /mydata/mysql/conf
#修改文件
vi my.cnf

[mysqld]
# 开启二进制日志并指定日志名前缀
log-bin=mysql-bin
# 设置唯一库ID
server-id=2

service mysql restart

# 登录mysql
mysql -u root -p

# 设置主库参数
mysql> CHANGE MASTER TO
 MASTER_HOST='xxx.xxx.xxx.xxx',  #主库ip
 MASTER_USER='replymeee',  # 用户
 MASTER_PASSWORD='replymeee', #密码
 MASTER_LOG_FILE='binlog.000006', #二进制文件
 MASTER_LOG_POS=856; #二进制位置

start slave;
#查看状态
show slave statusG;

如有问题，欢迎指正！