Debian Codegraph @

mysql-test/suite/x/r/connection_ipv6.result

raw
1 Preamble
2 CREATE USER `user_localhost`@`localhost`;
3 CREATE USER `user_127_0_0_1`@`127.0.0.1`;
4 CREATE USER `user_::1`@`::1`;
5 CREATE USER `user_0:0:0:0:0:0:0:1`@`0:0:0:0:0:0:0:1`;
6 CREATE USER `user_0::0000:0000:0000:0000:0001`@`0000:0000:0000:0000:0000:0000:0000:0001`;
7 CREATE USER `user_0:0:0:0:0:FFFF:127.0.0.1`@`0:0:0:0:0:FFFF:127.0.0.1`;
8 CREATE USER `user_::FFFF:127.0.0.1`@`::FFFF:127.0.0.1`;
9 #
10 #
11 # Server enabled with IPv4, test connectivity from localhosts
12 #
13 #
14 RUN SELECT user()
15 user()
16 user_localhost@localhost
17 0 rows affected
18 RUN SELECT @@global.mysqlx_bind_address
19 @@global.mysqlx_bind_address
20 0.0.0.0
21 0 rows affected
22 RUN SHOW STATUS LIKE 'mysqlx_address'
23 Variable_name Value
24 Mysqlx_address 0.0.0.0
25 0 rows affected
26 Mysqlx.Ok {
27 msg: "bye!"
28 }
29 RUN SELECT user()
30 user()
31 user_127_0_0_1@localhost
32 0 rows affected
33 RUN SELECT @@global.mysqlx_bind_address
34 @@global.mysqlx_bind_address
35 0.0.0.0
36 0 rows affected
37 RUN SHOW STATUS LIKE 'mysqlx_address'
38 Variable_name Value
39 Mysqlx_address 0.0.0.0
40 0 rows affected
41 Mysqlx.Ok {
42 msg: "bye!"
43 }
44 #
45 #
46 # Server enabled with IPv4, test connectivity from mapped localhost-ips
47 #
48 #
49 RUN SELECT user()
50 user()
51 user_localhost@localhost
52 0 rows affected
53 RUN SELECT @@global.mysqlx_bind_address
54 @@global.mysqlx_bind_address
55 0.0.0.0
56 0 rows affected
57 RUN SHOW STATUS LIKE 'mysqlx_address'
58 Variable_name Value
59 Mysqlx_address 0.0.0.0
60 0 rows affected
61 Mysqlx.Ok {
62 msg: "bye!"
63 }
64 RUN SELECT user()
65 user()
66 user_127_0_0_1@localhost
67 0 rows affected
68 RUN SELECT @@global.mysqlx_bind_address
69 @@global.mysqlx_bind_address
70 0.0.0.0
71 0 rows affected
72 RUN SHOW STATUS LIKE 'mysqlx_address'
73 Variable_name Value
74 Mysqlx_address 0.0.0.0
75 0 rows affected
76 Mysqlx.Ok {
77 msg: "bye!"
78 }
79 # restart: --loose-mysqlx-bind-address=::
80 #
81 #
82 # Server enabled with IPv6 and IPv4, test connectivity from localhosts
83 #
84 #
85 RUN SELECT user()
86 user()
87 user_localhost@localhost
88 0 rows affected
89 RUN SELECT @@global.mysqlx_bind_address
90 @@global.mysqlx_bind_address
91 ::
92 0 rows affected
93 RUN SHOW STATUS LIKE 'mysqlx_address'
94 Variable_name Value
95 Mysqlx_address ::
96 0 rows affected
97 Mysqlx.Ok {
98 msg: "bye!"
99 }
100 RUN SELECT user()
101 user()
102 user_localhost@localhost
103 0 rows affected
104 RUN SELECT @@global.mysqlx_bind_address
105 @@global.mysqlx_bind_address
106 ::
107 0 rows affected
108 RUN SHOW STATUS LIKE 'mysqlx_address'
109 Variable_name Value
110 Mysqlx_address ::
111 0 rows affected
112 Mysqlx.Ok {
113 msg: "bye!"
114 }
115 RUN SELECT user()
116 user()
117 user_127_0_0_1@localhost
118 0 rows affected
119 RUN SELECT @@global.mysqlx_bind_address
120 @@global.mysqlx_bind_address
121 ::
122 0 rows affected
123 RUN SHOW STATUS LIKE 'mysqlx_address'
124 Variable_name Value
125 Mysqlx_address ::
126 0 rows affected
127 Mysqlx.Ok {
128 msg: "bye!"
129 }
130 RUN SELECT user()
131 user()
132 user_::1@localhost
133 0 rows affected
134 RUN SELECT @@global.mysqlx_bind_address
135 @@global.mysqlx_bind_address
136 ::
137 0 rows affected
138 RUN SHOW STATUS LIKE 'mysqlx_address'
139 Variable_name Value
140 Mysqlx_address ::
141 0 rows affected
142 Mysqlx.Ok {
143 msg: "bye!"
144 }
145 #
146 #
147 # Server enabled with IPv6 and IPv4, test connectivity from mapped localhost-ips
148 #
149 #
150 RUN SELECT user()
151 user()
152 user_localhost@localhost
153 0 rows affected
154 RUN SELECT @@global.mysqlx_bind_address
155 @@global.mysqlx_bind_address
156 ::
157 0 rows affected
158 RUN SHOW STATUS LIKE 'mysqlx_address'
159 Variable_name Value
160 Mysqlx_address ::
161 0 rows affected
162 Mysqlx.Ok {
163 msg: "bye!"
164 }
165 RUN SELECT user()
166 user()
167 user_127_0_0_1@localhost
168 0 rows affected
169 RUN SELECT @@global.mysqlx_bind_address
170 @@global.mysqlx_bind_address
171 ::
172 0 rows affected
173 RUN SHOW STATUS LIKE 'mysqlx_address'
174 Variable_name Value
175 Mysqlx_address ::
176 0 rows affected
177 Mysqlx.Ok {
178 msg: "bye!"
179 }
180 # restart:
181 DROP USER `user_localhost`@`localhost`;
182 DROP USER `user_127_0_0_1`@`127.0.0.1`;
183 DROP USER `user_::1`@`::1`;
184 DROP USER `user_0:0:0:0:0:0:0:1`@`0:0:0:0:0:0:0:1`;
185 DROP USER `user_0::0000:0000:0000:0000:0001`@`0000:0000:0000:0000:0000:0000:0000:0001`;
186 DROP USER `user_0:0:0:0:0:FFFF:127.0.0.1`@`0:0:0:0:0:FFFF:127.0.0.1`;
187 DROP USER `user_::FFFF:127.0.0.1`@`::FFFF:127.0.0.1`;