MySQL Replication 연결

# Master 

mysql > show master status;

ex )
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000010 |  6696003 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

# Slave

mysql > stop slave;

mysql > change master to master_host = 'ip', master_port = 3306, master_user = 'user_id', master_password = 'user_password', master_log_pos =6696003, master_log_file = 'mysql-bin.000010';

mysql > start slave;

mysql > show slave status \G;

# 연결이 안 될시에 유저 권한 확인
select user,host,authentication_string from mysql.user order by user;