介绍
主库配置-共四步
//配置文件
log-bin=mysql-bin
server-id=100
//重启mysql
service mysql restart
//创建用户授权-mysql8版本
CREATE USER 'mjz'@'%' IDENTIFIED BY '123456';
GRANT REPLICATION SLAVE ON *.* TO 'mjz'@'%';
//刷新权限
FLUSH PRIVILEGES;
show master status;
从库配置-共四步
//配置文件
server-id=101
//重启mysql
service mysql restart
//关闭从库服务
stop slave;
//登陆mysql数据库,执行(一定要手动修改信息,复制上去会连接失败)
change master to master_host='192.168.126.xxx'(主库ip),master_user='mjz',master_password='123456',master_log_file='mysql-bin.000004',master_log_pos=xxx;
//启动从库服务
start slave;
show slave status;