1、演示环境
mysql> system cat /etc/RedHat-release
CentOS release 6.7 (Final)
mysql> show variables like 'version';
+---------------+------------+
| Variable_name | Value |
+---------------+------------+
| version | 5.7.12-log |
+---------------+------------+
主服务器:192.168.1.245:3306 server_id : 245
从服务器:192.168.1.247:3306 server_id : 247
--在主库端创建复制用户
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'%' IDENTIFIED BY '123456';
2、直接使用change master(针对本文第一部分,第1小点情形)
此处省略基于gtid配置的参数描述,具体可以参考:配置MySQL GTID 主从复制
在从服务器端直接change master,如下:
SLAVE> show variables like 'server_id';
+---------------+-------+
| Variable_name | Value |