Edit File: ipv6.result
=============Test of '::1' ======================================== mysqld is alive CREATE USER testuser@'::1' identified by '1234'; GRANT ALL ON test.* TO testuser@'::1'; SHOW GRANTS FOR testuser@'::1'; Grants for testuser@::1 GRANT USAGE ON *.* TO 'testuser'@'::1' IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' GRANT ALL PRIVILEGES ON `test`.* TO 'testuser'@'::1' SET @nip= inet_aton('::1'); SELECT @nip; @nip NULL SELECT inet_ntoa(@nip); inet_ntoa(@nip) NULL SELECT USER(); USER() root@localhost SELECT current_user(); current_user() root@localhost SHOW PROCESSLIST; REVOKE ALL ON test.* FROM testuser@'::1'; RENAME USER testuser@'::1' to testuser1@'::1'; SET PASSWORD FOR testuser1@'::1' = PASSWORD ('9876'); SELECT USER(); USER() root@localhost DROP USER testuser1@'::1'; =============Test of '::1/128' ==================================== =============Test of '0000:0000:0000:0000:0000:0000:0000:0001' ==== mysqld is alive CREATE USER testuser@'0000:0000:0000:0000:0000:0000:0000:0001' identified by '1234'; GRANT ALL ON test.* TO testuser@'0000:0000:0000:0000:0000:0000:0000:0001'; SHOW GRANTS FOR testuser@'0000:0000:0000:0000:0000:0000:0000:0001'; Grants for testuser@0000:0000:0000:0000:0000:0000:0000:0001 GRANT USAGE ON *.* TO 'testuser'@'0000:0000:0000:0000:0000:0000:0000:0001' IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' GRANT ALL PRIVILEGES ON `test`.* TO 'testuser'@'0000:0000:0000:0000:0000:0000:0000:0001' SET @nip= inet_aton('0000:0000:0000:0000:0000:0000:0000:0001'); SELECT @nip; @nip NULL SELECT inet_ntoa(@nip); inet_ntoa(@nip) NULL SELECT USER(); USER() root@localhost SELECT current_user(); current_user() root@localhost SHOW PROCESSLIST; REVOKE ALL ON test.* FROM testuser@'0000:0000:0000:0000:0000:0000:0000:0001'; RENAME USER testuser@'0000:0000:0000:0000:0000:0000:0000:0001' to testuser1@'0000:0000:0000:0000:0000:0000:0000:0001'; SET PASSWORD FOR testuser1@'0000:0000:0000:0000:0000:0000:0000:0001' = PASSWORD ('9876'); SELECT USER(); USER() root@localhost DROP USER testuser1@'0000:0000:0000:0000:0000:0000:0000:0001'; =============Test of '0:0:0:0:0:0:0:1' ============================ mysqld is alive CREATE USER testuser@'0:0:0:0:0:0:0:1' identified by '1234'; GRANT ALL ON test.* TO testuser@'0:0:0:0:0:0:0:1'; SHOW GRANTS FOR testuser@'0:0:0:0:0:0:0:1'; Grants for testuser@0:0:0:0:0:0:0:1 GRANT USAGE ON *.* TO 'testuser'@'0:0:0:0:0:0:0:1' IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' GRANT ALL PRIVILEGES ON `test`.* TO 'testuser'@'0:0:0:0:0:0:0:1' SET @nip= inet_aton('0:0:0:0:0:0:0:1'); SELECT @nip; @nip NULL SELECT inet_ntoa(@nip); inet_ntoa(@nip) NULL SELECT USER(); USER() root@localhost SELECT current_user(); current_user() root@localhost SHOW PROCESSLIST; REVOKE ALL ON test.* FROM testuser@'0:0:0:0:0:0:0:1'; RENAME USER testuser@'0:0:0:0:0:0:0:1' to testuser1@'0:0:0:0:0:0:0:1'; SET PASSWORD FOR testuser1@'0:0:0:0:0:0:0:1' = PASSWORD ('9876'); SELECT USER(); USER() root@localhost DROP USER testuser1@'0:0:0:0:0:0:0:1';
Back to File Manager