diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result b/mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result index 94bc660727a..31e4bc9f843 100644 --- a/mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result +++ b/mysql-test/suite/perfschema/r/hostcache_ipv4_max_con.result @@ -1,17 +1,29 @@ flush status; flush hosts; flush user_resources; +flush privileges; select @@global.debug; @@global.debug +select @@global.max_connect_errors; +@@global.max_connect_errors +100 select @@global.max_user_connections; @@global.max_user_connections 1024 -select @@global.max_user_connections into @saved_max_user_connections; select @@global.max_connections; @@global.max_connections 151 +select `User`, `Host` from mysql.`user` where `host` like '%\\%%'; +User Host +select `User`, `Host` from mysql.`user` where `user` like '192.%'; +User Host +select `User`, `Host` from mysql.`user` where `user` like '2001:%'; +User Host +select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%'; +User Host select @@global.max_connections into @saved_max_connections; +select @@global.max_user_connections into @saved_max_user_connections; create user 'quota'@'santa.claus.ipv4.example.com'; grant select on test.* to 'quota'@'santa.claus.ipv4.example.com'; grant usage on *.* to 'quota'@'santa.claus.ipv4.example.com' |