MySql Replication主从环境搭建

SHOW VARIABLES LIKE 'log_bin';
SHOW VARIABLES LIKE 'binlog_format';
SHOW VARIABLES LIKE 'server_id';
SHOW VARIABLES LIKE 'innodb_flush_log_at_trx_commit';
SHOW VARIABLES LIKE 'sync_binlog';
SHOW VARIABLES LIKE 'skip_networking';

log_bin                                        ON
binlog_format                                  ROW
server_id                                      1
innodb_flush_log_at_trx_commit                 1
sync_binlog                                    1
skip_networking                                OFF

server-id=101
skip-log-bin=ON

SHOW VARIABLES LIKE 'log_bin';
SHOW VARIABLES LIKE 'server_id';
SHOW VARIABLES LIKE '%relay%';

log_bin                                        ON
server_id                                      101

CREATE USER 'replication' IDENTIFIED WITH  mysql_native_password BY 'replication';
GRANT REPLICATION SLAVE ON *.* TO 'replication';
FLUSH PRIVILEGES;

SHOW CREATE USER 'replication';
SHOW GRANTS FOR 'replication';

FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;