mysql8 复制

// 主库 备库均创建用户
// 先创建用户
create user 'repl'@'127.0.0.1';
// 如果是mysql8 的话 其密码验证使用的是sha256_password
alter user 'repl'@'127.0.0.1' identified with sha256_password by '123456';
// 赋予权限
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'127.0.0.1'
// 修改配置文件
// 主库
[mysqld]
datadir=/usr/local/mysql/3306
socket=/usr/local/mysql/3306/mysql.sock
log_bin=/usr/local/mysql/3306/mysql_bin
log_error=/usr/local/mysql/3306/mysql_error.log
server_id=3306
port=3306
user=mysql
// 从库
[mysqld]
datadir=/usr/local/mysql/3307
socket=/usr/local/mysql/3307/mysql.sock
log_bin=/usr/local/mysql/3307/mysql_bin
log_error=/usr/local/mysql/3307/mysql_error.log
server_id=3307
port=3307
user=mysql
log_slave_updates=1 //允许备库将重放的事件也放到自身的二进制日志中
// 进入主库 执行
show master status;
// 进入从库
help CHANGE MASTER TO // 查看连接主库命令
// 连接主库
CHANGE MASTER TO MASTER_HOST='127.0.0.1',
MASTER_PORT=3306,MASTER_USER='repl',MASTER_PASSWORD='123456',
MASTER_LOG_FILE='mysql_bin.000004',MASTER_LOG_POS=156

start slave;
// 停止连接 stop slave
// 从库查看连接状态
show slave status\G;