1#################### IP: ::1 ###########################
2connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
3connect (slave,::1,root,,test,SLAVE_MYPORT);
4connection master;
5reset master;
6show master status;
7File	Position	Binlog_Do_DB	Binlog_Ignore_DB	Executed_Gtid_Set
8master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>	<Executed_Gtid_Set>
9connection slave;
10reset slave;
11Master-Host: No such row
12change master to master_host='::1';
13Master-Host: ::1
14disconnect slave;
15disconnect master;
16connection default;
17#################### IP: 0000:0000:0000:0000:0000:0000:0000:0001 ###########################
18connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
19connect (slave,0000:0000:0000:0000:0000:0000:0000:0001,root,,test,SLAVE_MYPORT);
20connection master;
21reset master;
22show master status;
23File	Position	Binlog_Do_DB	Binlog_Ignore_DB	Executed_Gtid_Set
24master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>	<Executed_Gtid_Set>
25connection slave;
26reset slave;
27Master-Host: ::1
28change master to master_host='0000:0000:0000:0000:0000:0000:0000:0001';
29Master-Host: 0000:0000:0000:0000:0000:0000:0000:0001
30disconnect slave;
31disconnect master;
32connection default;
33#################### IP: 0:0:0:0:0:0:0:1 ###########################
34connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
35connect (slave,0:0:0:0:0:0:0:1,root,,test,SLAVE_MYPORT);
36connection master;
37reset master;
38show master status;
39File	Position	Binlog_Do_DB	Binlog_Ignore_DB	Executed_Gtid_Set
40master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>	<Executed_Gtid_Set>
41connection slave;
42reset slave;
43Master-Host: 0000:0000:0000:0000:0000:0000:0000:0001
44change master to master_host='0:0:0:0:0:0:0:1';
45Master-Host: 0:0:0:0:0:0:0:1
46disconnect slave;
47disconnect master;
48connection default;
49#################### IP: ::1 mix #######################
50connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
51connect (slave,::1,root,,test,SLAVE_MYPORT);
52connection master;
53reset master;
54show master status;
55File	Position	Binlog_Do_DB	Binlog_Ignore_DB	Executed_Gtid_Set
56master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>	<Executed_Gtid_Set>
57connection slave;
58reset slave;
59Master-Host: 0:0:0:0:0:0:0:1
60change master to master_host='::1';
61Master-Host: ::1
62change master to master_host='127.0.0.1';
63Master-Host: 127.0.0.1
64change master to master_host='0:0:0:0:0:0:0:1';
65Master-Host: 0:0:0:0:0:0:0:1
66CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root';
67Warnings:
68Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
69Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
70