Mysql数据库主从数据库快速搭建

1.修改server-id 主从分别设置为1 和 2

vi /etc/my.cnf 

[mysqld] 
server-id=1

2.主库创建用户

mysql>CREATE USER 'repl'@'%' IDENTIFIED WITH mysql_native_password BY 'repl';
mysql>GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';

刷新

mysql>flush privileges;

3.mysql>SHOW MASTER STATUS; 之后不要进行操作 去从库操作

4.从节点操作设置主主节点参数
MASTER_LOG_FILE 为图中Flie值

mysql>CHANGE MASTER TO MASTER_HOST='192.168.1.8', MASTER_USER='repl', MASTER_PASSWORD='repl', 
MASTER_LOG_FILE='binlog.000007', MASTER_LOG_POS=4771;

5.mysql>flush privileges; 刷新
6.mysql>start slave; 启动从库
7.mysql>show slave status\G; 确认 IO SQL都为yes

8.如果失败 停止salve

mysql>stop slave;

重复3-6步骤