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