1=============Test of '127.0.0.1' (IPv4) ===========================
2mysqld is alive
3CREATE USER testuser@'127.0.0.1' identified by '1234';
4GRANT ALL ON test.* TO testuser@'127.0.0.1';
5SHOW GRANTS FOR testuser@'127.0.0.1';
6Grants for testuser@127.0.0.1
7GRANT USAGE ON *.* TO `testuser`@`127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
8GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`127.0.0.1`
9SET @nip= inet_aton('127.0.0.1');
10SELECT @nip;
11@nip
122130706433
13SELECT inet_ntoa(@nip);
14inet_ntoa(@nip)
15127.0.0.1
16SELECT USER();
17USER()
18root@localhost
19SELECT current_user();
20current_user()
21root@localhost
22SHOW PROCESSLIST;
23connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
24connection default;
25disconnect con1;
26REVOKE ALL ON test.* FROM testuser@'127.0.0.1';
27RENAME USER testuser@'127.0.0.1' to testuser1@'127.0.0.1';
28SET PASSWORD FOR testuser1@'127.0.0.1' = PASSWORD ('9876');
29SELECT USER();
30USER()
31root@localhost
32DROP USER testuser1@'127.0.0.1';
33=============Test of '0:0:0:0:0:FFFF:127.0.0.1' ===================
34mysqld is alive
35CREATE USER testuser@'0:0:0:0:0:FFFF:127.0.0.1' identified by '1234';
36GRANT ALL ON test.* TO testuser@'0:0:0:0:0:FFFF:127.0.0.1';
37SHOW GRANTS FOR testuser@'0:0:0:0:0:FFFF:127.0.0.1';
38Grants for testuser@0:0:0:0:0:ffff:127.0.0.1
39GRANT USAGE ON *.* TO `testuser`@`0:0:0:0:0:ffff:127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
40GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`0:0:0:0:0:ffff:127.0.0.1`
41SET @nip= inet_aton('0:0:0:0:0:FFFF:127.0.0.1');
42SELECT @nip;
43@nip
44NULL
45SELECT inet_ntoa(@nip);
46inet_ntoa(@nip)
47NULL
48SELECT USER();
49USER()
50root@localhost
51SELECT current_user();
52current_user()
53root@localhost
54SHOW PROCESSLIST;
55connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
56connection default;
57disconnect con1;
58REVOKE ALL ON test.* FROM testuser@'0:0:0:0:0:FFFF:127.0.0.1';
59RENAME USER testuser@'0:0:0:0:0:FFFF:127.0.0.1' to testuser1@'0:0:0:0:0:FFFF:127.0.0.1';
60SET PASSWORD FOR testuser1@'0:0:0:0:0:FFFF:127.0.0.1' = PASSWORD ('9876');
61SELECT USER();
62USER()
63root@localhost
64DROP USER testuser1@'0:0:0:0:0:FFFF:127.0.0.1';
65=============Test of '0000:0000:0000:0000:0000:FFFF:127.0.0.1' ====
66mysqld is alive
67CREATE USER testuser@'0000:0000:0000:0000:0000:FFFF:127.0.0.1' identified by '1234';
68GRANT ALL ON test.* TO testuser@'0000:0000:0000:0000:0000:FFFF:127.0.0.1';
69SHOW GRANTS FOR testuser@'0000:0000:0000:0000:0000:FFFF:127.0.0.1';
70Grants for testuser@0000:0000:0000:0000:0000:ffff:127.0.0.1
71GRANT USAGE ON *.* TO `testuser`@`0000:0000:0000:0000:0000:ffff:127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
72GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`0000:0000:0000:0000:0000:ffff:127.0.0.1`
73SET @nip= inet_aton('0000:0000:0000:0000:0000:FFFF:127.0.0.1');
74SELECT @nip;
75@nip
76NULL
77SELECT inet_ntoa(@nip);
78inet_ntoa(@nip)
79NULL
80SELECT USER();
81USER()
82root@localhost
83SELECT current_user();
84current_user()
85root@localhost
86SHOW PROCESSLIST;
87connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
88connection default;
89disconnect con1;
90REVOKE ALL ON test.* FROM testuser@'0000:0000:0000:0000:0000:FFFF:127.0.0.1';
91RENAME USER testuser@'0000:0000:0000:0000:0000:FFFF:127.0.0.1' to testuser1@'0000:0000:0000:0000:0000:FFFF:127.0.0.1';
92SET PASSWORD FOR testuser1@'0000:0000:0000:0000:0000:FFFF:127.0.0.1' = PASSWORD ('9876');
93SELECT USER();
94USER()
95root@localhost
96DROP USER testuser1@'0000:0000:0000:0000:0000:FFFF:127.0.0.1';
97=============Test of '0:0000:0000:0:0000:FFFF:127.0.0.1' ====
98mysqld is alive
99CREATE USER testuser@'0:0000:0000:0:0000:FFFF:127.0.0.1' identified by '1234';
100GRANT ALL ON test.* TO testuser@'0:0000:0000:0:0000:FFFF:127.0.0.1';
101SHOW GRANTS FOR testuser@'0:0000:0000:0:0000:FFFF:127.0.0.1';
102Grants for testuser@0:0000:0000:0:0000:ffff:127.0.0.1
103GRANT USAGE ON *.* TO `testuser`@`0:0000:0000:0:0000:ffff:127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
104GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`0:0000:0000:0:0000:ffff:127.0.0.1`
105SET @nip= inet_aton('0:0000:0000:0:0000:FFFF:127.0.0.1');
106SELECT @nip;
107@nip
108NULL
109SELECT inet_ntoa(@nip);
110inet_ntoa(@nip)
111NULL
112SELECT USER();
113USER()
114root@localhost
115SELECT current_user();
116current_user()
117root@localhost
118SHOW PROCESSLIST;
119connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
120connection default;
121disconnect con1;
122REVOKE ALL ON test.* FROM testuser@'0:0000:0000:0:0000:FFFF:127.0.0.1';
123RENAME USER testuser@'0:0000:0000:0:0000:FFFF:127.0.0.1' to testuser1@'0:0000:0000:0:0000:FFFF:127.0.0.1';
124SET PASSWORD FOR testuser1@'0:0000:0000:0:0000:FFFF:127.0.0.1' = PASSWORD ('9876');
125SELECT USER();
126USER()
127root@localhost
128DROP USER testuser1@'0:0000:0000:0:0000:FFFF:127.0.0.1';
129=============Test of '0::0000:FFFF:127.0.0.1' ====
130mysqld is alive
131CREATE USER testuser@'0::0000:FFFF:127.0.0.1' identified by '1234';
132GRANT ALL ON test.* TO testuser@'0::0000:FFFF:127.0.0.1';
133SHOW GRANTS FOR testuser@'0::0000:FFFF:127.0.0.1';
134Grants for testuser@0::0000:ffff:127.0.0.1
135GRANT USAGE ON *.* TO `testuser`@`0::0000:ffff:127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
136GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`0::0000:ffff:127.0.0.1`
137SET @nip= inet_aton('0::0000:FFFF:127.0.0.1');
138SELECT @nip;
139@nip
140NULL
141SELECT inet_ntoa(@nip);
142inet_ntoa(@nip)
143NULL
144SELECT USER();
145USER()
146root@localhost
147SELECT current_user();
148current_user()
149root@localhost
150SHOW PROCESSLIST;
151connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
152connection default;
153disconnect con1;
154REVOKE ALL ON test.* FROM testuser@'0::0000:FFFF:127.0.0.1';
155RENAME USER testuser@'0::0000:FFFF:127.0.0.1' to testuser1@'0::0000:FFFF:127.0.0.1';
156SET PASSWORD FOR testuser1@'0::0000:FFFF:127.0.0.1' = PASSWORD ('9876');
157SELECT USER();
158USER()
159root@localhost
160DROP USER testuser1@'0::0000:FFFF:127.0.0.1';
161=============Test of '0:0:0:0:0:FFFF:127.0.0.1/96' ================
162=============Test of '::FFFF:127.0.0.1' ===========================
163mysqld is alive
164CREATE USER testuser@'::FFFF:127.0.0.1' identified by '1234';
165GRANT ALL ON test.* TO testuser@'::FFFF:127.0.0.1';
166SHOW GRANTS FOR testuser@'::FFFF:127.0.0.1';
167Grants for testuser@::ffff:127.0.0.1
168GRANT USAGE ON *.* TO `testuser`@`::ffff:127.0.0.1` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF'
169GRANT ALL PRIVILEGES ON `test`.* TO `testuser`@`::ffff:127.0.0.1`
170SET @nip= inet_aton('::FFFF:127.0.0.1');
171SELECT @nip;
172@nip
173NULL
174SELECT inet_ntoa(@nip);
175inet_ntoa(@nip)
176NULL
177SELECT USER();
178USER()
179root@localhost
180SELECT current_user();
181current_user()
182root@localhost
183SHOW PROCESSLIST;
184connect  con1, $IPv6, root, , test, $MASTER_MYPORT;
185connection default;
186disconnect con1;
187REVOKE ALL ON test.* FROM testuser@'::FFFF:127.0.0.1';
188RENAME USER testuser@'::FFFF:127.0.0.1' to testuser1@'::FFFF:127.0.0.1';
189SET PASSWORD FOR testuser1@'::FFFF:127.0.0.1' = PASSWORD ('9876');
190SELECT USER();
191USER()
192root@localhost
193DROP USER testuser1@'::FFFF:127.0.0.1';
194=============Test of '::FFFF:127.0.0.1/96' ========================
195=============Test of '::1' ========================
196connect (con1, ::1, root, , test, MASTER_MYPORT,);
197Got one of the listed errors
198