master：192.168.0.125

slave：192.168.0.126

主：

修改配置i文件

vim /etc/my.cnf

[mysqld]
log-bin=mysql-bin
server-id=1

重启MySQL，然后登录进MySQL

创建用来同步的账号

use mysql;

mysql> create user 'ckx'@'192.168.0.%' identified with mysql_native_password by '***';

mysql> grant replication slave on *.* to 'ckx'@'192.168.0.%';

刷新配置：

mysql> flush privileges;

查看状态

mysql>SHOW MASTER STATUS;

+------------------------+------------+--------------+-------------------------------+---------------------------+
| File                        | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------------+------------+--------------+-------------------------------+---------------------------+
| mysql-bin.000001 |     2983   |                 |                                       |                                 |
+------------------------+-----------+--------------+--------------------------------+---------------------------+

将file和position记下来

从：

修改配置i文件

vim /etc/my.cnf

[mysqld]
server-id=2

重启MySQL，然后登录进MySQL

执行同步SQL语句，需要输入刚再master的IP地址，授权账号，账号密码，和刚才记录的file二进制文件和position

mysql>CHANGE MASTER TO MASTER_HOST='192.168.0.125', MASTER_USER='ckx',MASTER_PASSWORD='Logitech@123', MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=2983;

启动slave同步

mysql> start slave;

查看同步状态

mysql> show slave status\G

Slave_IO_Running和Slave_SQL_Running都为YES的话就表示同步成功了。