Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ipv4_as_ipv6.result

raw
1 # connecting to a slave to add accounts [email protected], root@::1
2 #################### IP: 127.0.0.1 ###########################
3 connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
4 connect (slave,127.0.0.1,root,,test,SLAVE_MYPORT);
5 connection master;
6 reset master;
7 show master status;
8 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
9 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
10 connection slave;
11 reset slave;
12 Warnings:
13 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
14 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1';
15 Master-Host: 127.0.0.1
16 disconnect slave;
17 disconnect master;
18 connection default;
19 #################### IP: 0:0:0:0:0:FFFF:127.0.0.1 ###########################
20 connect (master,0:0:0:0:0:FFFF:127.0.0.1,root,,test,MASTER_MYPORT);
21 connect (slave,0:0:0:0:0:FFFF:127.0.0.1,root,,test,SLAVE_MYPORT);
22 connection master;
23 reset master;
24 show master status;
25 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
26 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
27 connection slave;
28 reset slave;
29 Warnings:
30 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
31 CHANGE REPLICATION SOURCE TO SOURCE_HOST='0:0:0:0:0:FFFF:127.0.0.1';
32 Master-Host: 0:0:0:0:0:FFFF:127.0.0.1
33 disconnect slave;
34 disconnect master;
35 connection default;
36 #################### IP: 0000:0000:0000:0000:0000:FFFF:127.0.0.1 ###########################
37 connect (master,0000:0000:0000:0000:0000:FFFF:127.0.0.1,root,,test,MASTER_MYPORT);
38 connect (slave,0000:0000:0000:0000:0000:FFFF:127.0.0.1,root,,test,SLAVE_MYPORT);
39 connection master;
40 reset master;
41 show master status;
42 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
43 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
44 connection slave;
45 reset slave;
46 Warnings:
47 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
48 CHANGE REPLICATION SOURCE TO SOURCE_HOST='0000:0000:0000:0000:0000:FFFF:127.0.0.1';
49 Master-Host: 0000:0000:0000:0000:0000:FFFF:127.0.0.1
50 disconnect slave;
51 disconnect master;
52 connection default;
53 #################### IP: 0:0000:0000:0:0000:FFFF:127.0.0.1 ###########################
54 connect (master,0:0000:0000:0:0000:FFFF:127.0.0.1,root,,test,MASTER_MYPORT);
55 connect (slave,0:0000:0000:0:0000:FFFF:127.0.0.1,root,,test,SLAVE_MYPORT);
56 connection master;
57 reset master;
58 show master status;
59 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
60 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
61 connection slave;
62 reset slave;
63 Warnings:
64 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
65 CHANGE REPLICATION SOURCE TO SOURCE_HOST='0:0000:0000:0:0000:FFFF:127.0.0.1';
66 Master-Host: 0:0000:0000:0:0000:FFFF:127.0.0.1
67 disconnect slave;
68 disconnect master;
69 connection default;
70 #################### IP: 0::0000:FFFF:127.0.0.1 ###########################
71 connect (master,0::0000:FFFF:127.0.0.1,root,,test,MASTER_MYPORT);
72 connect (slave,0::0000:FFFF:127.0.0.1,root,,test,SLAVE_MYPORT);
73 connection master;
74 reset master;
75 show master status;
76 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
77 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
78 connection slave;
79 reset slave;
80 Warnings:
81 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
82 CHANGE REPLICATION SOURCE TO SOURCE_HOST='0::0000:FFFF:127.0.0.1';
83 Master-Host: 0::0000:FFFF:127.0.0.1
84 disconnect slave;
85 disconnect master;
86 connection default;
87 #################### IP: ::FFFF:127.0.0.1 ###########################
88 connect (master,::FFFF:127.0.0.1,root,,test,MASTER_MYPORT);
89 connect (slave,::FFFF:127.0.0.1,root,,test,SLAVE_MYPORT);
90 connection master;
91 reset master;
92 show master status;
93 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
94 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
95 connection slave;
96 reset slave;
97 Warnings:
98 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
99 CHANGE REPLICATION SOURCE TO SOURCE_HOST='::FFFF:127.0.0.1';
100 Master-Host: ::FFFF:127.0.0.1
101 disconnect slave;
102 disconnect master;
103 connection default;
104 #################### IP: ::FFFF:127.0.0.1 ###########################
105 connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
106 connect (slave,127.0.0.1,root,,test,SLAVE_MYPORT);
107 connection master;
108 reset master;
109 show master status;
110 File Position Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set
111 master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB> <Executed_Gtid_Set>
112 connection slave;
113 reset slave;
114 Warnings:
115 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
116 Master-Host: ::FFFF:127.0.0.1
117 change replication source to source_host='::FFFF:127.0.0.1';
118 Master-Host: ::FFFF:127.0.0.1
119 change replication source to source_host='127.0.0.1';
120 Master-Host: 127.0.0.1
121 change replication source to source_host='0:0000:0000:0:0000:FFFF:127.0.0.1';
122 Master-Host: 0:0000:0000:0:0000:FFFF:127.0.0.1
123 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root';
124 Warnings:
125 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
126 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.