1#################### IP: 127.0.0.1 ########################### 2connect master,$IPv6,root,,test,$MASTER_MYPORT; 3connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 4connection master; 5reset master; 6show master status; 7File Position Binlog_Do_DB Binlog_Ignore_DB 8master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 9connection slave; 10reset slave; 11change master to master_host='127.0.0.1'; 12Master-Host: 127.0.0.1 13disconnect slave; 14disconnect master; 15connection default; 16#################### IP: 0:0:0:0:0:FFFF:127.0.0.1 ########################### 17connect master,$IPv6,root,,test,$MASTER_MYPORT; 18connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 19connection master; 20reset master; 21show master status; 22File Position Binlog_Do_DB Binlog_Ignore_DB 23master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 24connection slave; 25reset slave; 26change master to master_host='0:0:0:0:0:FFFF:127.0.0.1'; 27Master-Host: 0:0:0:0:0:FFFF:127.0.0.1 28disconnect slave; 29disconnect master; 30connection default; 31#################### IP: 0000:0000:0000:0000:0000:FFFF:127.0.0.1 ########################### 32connect master,$IPv6,root,,test,$MASTER_MYPORT; 33connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 34connection master; 35reset master; 36show master status; 37File Position Binlog_Do_DB Binlog_Ignore_DB 38master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 39connection slave; 40reset slave; 41change master to master_host='0000:0000:0000:0000:0000:FFFF:127.0.0.1'; 42Master-Host: 0000:0000:0000:0000:0000:FFFF:127.0.0.1 43disconnect slave; 44disconnect master; 45connection default; 46#################### IP: 0:0000:0000:0:0000:FFFF:127.0.0.1 ########################### 47connect master,$IPv6,root,,test,$MASTER_MYPORT; 48connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 49connection master; 50reset master; 51show master status; 52File Position Binlog_Do_DB Binlog_Ignore_DB 53master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 54connection slave; 55reset slave; 56change master to master_host='0:0000:0000:0:0000:FFFF:127.0.0.1'; 57Master-Host: 0:0000:0000:0:0000:FFFF:127.0.0.1 58disconnect slave; 59disconnect master; 60connection default; 61#################### IP: 0::0000:FFFF:127.0.0.1 ########################### 62connect master,$IPv6,root,,test,$MASTER_MYPORT; 63connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 64connection master; 65reset master; 66show master status; 67File Position Binlog_Do_DB Binlog_Ignore_DB 68master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 69connection slave; 70reset slave; 71change master to master_host='0::0000:FFFF:127.0.0.1'; 72Master-Host: 0::0000:FFFF:127.0.0.1 73disconnect slave; 74disconnect master; 75connection default; 76#################### IP: ::FFFF:127.0.0.1 ########################### 77connect master,$IPv6,root,,test,$MASTER_MYPORT; 78connect slave,$IPv6,root,,test,$SLAVE_MYPORT; 79connection master; 80reset master; 81show master status; 82File Position Binlog_Do_DB Binlog_Ignore_DB 83master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 84connection slave; 85reset slave; 86change master to master_host='::FFFF:127.0.0.1'; 87Master-Host: ::FFFF:127.0.0.1 88disconnect slave; 89disconnect master; 90connection default; 91#################### IP: ::FFFF:127.0.0.1 ########################### 92connect master,127.0.0.1,root,,test,$MASTER_MYPORT; 93connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT; 94connection master; 95reset master; 96show master status; 97File Position Binlog_Do_DB Binlog_Ignore_DB 98master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> 99connection slave; 100reset slave; 101Master-Host: ::FFFF:127.0.0.1 102change master to master_host='::FFFF:127.0.0.1'; 103Master-Host: ::FFFF:127.0.0.1 104change master to master_host='127.0.0.1'; 105Master-Host: 127.0.0.1 106change master to master_host='0:0000:0000:0:0000:FFFF:127.0.0.1'; 107Master-Host: 0:0000:0000:0:0000:FFFF:127.0.0.1 108CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root'; 109