#################### IP: ::1 ########################### connect (master,127.0.0.1,root,,test,MASTER_MYPORT); connect (slave,::1,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,0000:0000:0000:0000:0000:0000:0000:0001,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,0:0:0:0:0:0:0:1,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,::1,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';