summaryrefslogtreecommitdiff
path: root/mysql-test/t/skip_name_resolve.test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-02-14 20:33:14 -0800
committerunknown <jimw@mysql.com>2005-02-14 20:33:14 -0800
commitddcb947ff73d89233093fb696212a8f788c952df (patch)
tree9f04b77005b330cf45838745b39a307a3112cc1e /mysql-test/t/skip_name_resolve.test
parent1b46843c10d1e5d2d6589acbb61cc1a3d8d9a4e1 (diff)
downloadmariadb-git-ddcb947ff73d89233093fb696212a8f788c952df.tar.gz
Allow hostnames that are IP addresses with a netmask even when
running with --skip-name-resolve. (Bug #8471) sql/sql_acl.cc: Add '/' to list of characters that doesn't trigger a need for resolving the hostname, so that the IP mask syntax works with skip-name-resolve.
Diffstat (limited to 'mysql-test/t/skip_name_resolve.test')
-rw-r--r--mysql-test/t/skip_name_resolve.test5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/skip_name_resolve.test b/mysql-test/t/skip_name_resolve.test
new file mode 100644
index 00000000000..68dcf329427
--- /dev/null
+++ b/mysql-test/t/skip_name_resolve.test
@@ -0,0 +1,5 @@
+# Bug #8471: IP address with mask fail when skip-name-resolve is on
+GRANT ALL ON test.* TO mysqltest_1@'127.0.0.1/255.255.255.255';
+SHOW GRANTS FOR mysqltest_1@'127.0.0.1/255.255.255.255';
+REVOKE ALL ON test.* FROM mysqltest_1@'127.0.0.1/255.255.255.255';
+DROP USER mysqltest_1@'127.0.0.1/255.255.255.255';