diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result b/mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result index ced889c363b..69f68de8d90 100644 --- a/mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result +++ b/mysql-test/suite/perfschema/r/hostcache_ipv4_passwd.result @@ -1,9 +1,27 @@ 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 +0 +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 create user 'user_without'@'santa.claus.ipv4.example.com'; create user 'user_with'@'santa.claus.ipv4.example.com' identified by 'good_password'; |