#################### IP: ::1 ########################### connect master,127.0.0.1,root,,test,$MASTER_MYPORT; connect slave,$IPv6,root,,test,$SLAVE_MYPORT; connection master; reset master; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 # connection slave; reset slave; Master-Host: No such row change master to master_host='::1'; Master-Host: ::1 disconnect slave; disconnect master; connection default; #################### IP: 0000:0000:0000:0000:0000:0000:0000:0001 ########################### connect master,127.0.0.1,root,,test,$MASTER_MYPORT; connect slave,$IPv6,root,,test,$SLAVE_MYPORT; connection master; reset master; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 # connection slave; reset slave; Master-Host: ::1 change master to master_host='0000:0000:0000:0000:0000:0000:0000:0001'; Master-Host: 0000:0000:0000:0000:0000:0000:0000:0001 disconnect slave; disconnect master; connection default; #################### IP: 0:0:0:0:0:0:0:1 ########################### connect master,127.0.0.1,root,,test,$MASTER_MYPORT; connect slave,$IPv6,root,,test,$SLAVE_MYPORT; connection master; reset master; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 # connection slave; reset slave; Master-Host: 0000:0000:0000:0000:0000:0000:0000:0001 change master to master_host='0:0:0:0:0:0:0:1'; Master-Host: 0:0:0:0:0:0:0:1 disconnect slave; disconnect master; connection default; #################### IP: ::1 mix ####################### connect master,127.0.0.1,root,,test,$MASTER_MYPORT; connect slave,$IPv6,root,,test,$SLAVE_MYPORT; connection master; reset master; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000001 # connection slave; reset slave; Master-Host: 0:0:0:0:0:0:0:1 change master to master_host='::1'; Master-Host: ::1 change master to master_host='127.0.0.1'; Master-Host: 127.0.0.1 change master to master_host='0:0:0:0:0:0:0:1'; Master-Host: 0:0:0:0:0:0:0:1 CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root'; connection slave; reset slave all;