summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema')
-rw-r--r--mysql-test/suite/perfschema/r/connect_attrs.result2
-rw-r--r--mysql-test/suite/perfschema/r/global_read_lock.result2
-rw-r--r--mysql-test/suite/perfschema/r/grant.result2
-rw-r--r--mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result2
-rw-r--r--mysql-test/suite/perfschema/r/privilege.result5
-rw-r--r--mysql-test/suite/perfschema/r/privilege_table_io.result2
-rw-r--r--mysql-test/suite/perfschema/r/read_only.result4
-rw-r--r--mysql-test/suite/perfschema/t/connect_attrs.test2
-rw-r--r--mysql-test/suite/perfschema/t/global_read_lock.test2
-rw-r--r--mysql-test/suite/perfschema/t/grant.test2
-rw-r--r--mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test2
-rw-r--r--mysql-test/suite/perfschema/t/privilege.test5
-rw-r--r--mysql-test/suite/perfschema/t/read_only.test4
13 files changed, 20 insertions, 16 deletions
diff --git a/mysql-test/suite/perfschema/r/connect_attrs.result b/mysql-test/suite/perfschema/r/connect_attrs.result
index eb83cb5e886..f262e6e5a84 100644
--- a/mysql-test/suite/perfschema/r/connect_attrs.result
+++ b/mysql-test/suite/perfschema/r/connect_attrs.result
@@ -25,7 +25,7 @@ FROM performance_schema.session_account_connect_attrs;
COUNT(DISTINCT PROCESSLIST_ID)
1
CREATE USER wl5924@localhost;
-connect non_privileged_user,localhost,wl5924,,test;
+connect non_privileged_user,localhost,wl5924,,"*NO-ONE*";
connection default;
# must return 1
SELECT COUNT(DISTINCT PROCESSLIST_ID)
diff --git a/mysql-test/suite/perfschema/r/global_read_lock.result b/mysql-test/suite/perfschema/r/global_read_lock.result
index df98b9bd1bb..31e1751d7b9 100644
--- a/mysql-test/suite/perfschema/r/global_read_lock.result
+++ b/mysql-test/suite/perfschema/r/global_read_lock.result
@@ -3,7 +3,7 @@ update performance_schema.setup_instruments set enabled='YES';
create user pfsuser@localhost;
grant SELECT, UPDATE, LOCK TABLES on performance_schema.* to pfsuser@localhost;
flush privileges;
-connect con1, localhost, pfsuser, , test;
+connect con1, localhost, pfsuser, ,"*NO-ONE*";
lock tables performance_schema.setup_instruments read;
select * from performance_schema.setup_instruments;
unlock tables;
diff --git a/mysql-test/suite/perfschema/r/grant.result b/mysql-test/suite/perfschema/r/grant.result
index 4679499279f..7424a8d2ce8 100644
--- a/mysql-test/suite/perfschema/r/grant.result
+++ b/mysql-test/suite/perfschema/r/grant.result
@@ -1,5 +1,5 @@
create user a@localhost;
-connect a,localhost,a;
+connect a,localhost,a,,"*NO-ONE*";
select * from performance_schema.global_status where variable_name='b';
VARIABLE_NAME VARIABLE_VALUE
connection default;
diff --git a/mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result b/mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result
index 6e3d928509c..2e9d1653b50 100644
--- a/mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result
+++ b/mysql-test/suite/perfschema/r/hostcache_ipv4_auth_ed25519.result
@@ -81,7 +81,7 @@ COUNT_LOCAL_ERRORS 0
COUNT_UNKNOWN_ERRORS 0
FIRST_ERROR_SEEN set
LAST_ERROR_SEEN set
-connect con1, 127.0.0.1, plug2,foo,,$MASTER_MYPORT;
+connect con1, 127.0.0.1, plug2,foo,"*NO-ONE*",$MASTER_MYPORT;
select current_user();
current_user()
plug2@santa.claus.ipv4.example.com
diff --git a/mysql-test/suite/perfschema/r/privilege.result b/mysql-test/suite/perfschema/r/privilege.result
index c5e0ebf3c92..3d52bb30b92 100644
--- a/mysql-test/suite/perfschema/r/privilege.result
+++ b/mysql-test/suite/perfschema/r/privilege.result
@@ -5,6 +5,9 @@ GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION
create user 'pfs_user_1'@localhost;
create user 'pfs_user_2'@localhost;
create user 'pfs_user_3'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_1'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_2'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_3'@localhost;
grant ALL on *.* to 'pfs_user_1'@localhost with GRANT OPTION;
grant ALL on performance_schema.* to 'pfs_user_2'@localhost
with GRANT OPTION;
@@ -521,7 +524,7 @@ flush privileges;
# Test cases from WL#4818
# Setup user
CREATE user pfs_user_4;
-connect pfs_user_4, localhost, pfs_user_4, , ;
+connect pfs_user_4, localhost, pfs_user_4, ,"*NO-ONE*";
#
# WL#4818, NFS4: Normal user does not have access to view data
# without grants
diff --git a/mysql-test/suite/perfschema/r/privilege_table_io.result b/mysql-test/suite/perfschema/r/privilege_table_io.result
index 94cc2b33b49..6dd885281b3 100644
--- a/mysql-test/suite/perfschema/r/privilege_table_io.result
+++ b/mysql-test/suite/perfschema/r/privilege_table_io.result
@@ -119,8 +119,6 @@ wait/io/table/sql/handler TABLE mysql global_priv fetch 1
wait/io/table/sql/handler TABLE mysql global_priv fetch 1
wait/io/table/sql/handler TABLE mysql global_priv fetch 1
wait/io/table/sql/handler TABLE mysql db fetch 1
-wait/io/table/sql/handler TABLE mysql db fetch 1
-wait/io/table/sql/handler TABLE mysql db fetch 1
wait/io/table/sql/handler TABLE mysql proxies_priv fetch 1
wait/io/table/sql/handler TABLE mysql proxies_priv fetch 1
wait/io/table/sql/handler TABLE mysql proxies_priv fetch 1
diff --git a/mysql-test/suite/perfschema/r/read_only.result b/mysql-test/suite/perfschema/r/read_only.result
index 344526bbd63..aa18efc928f 100644
--- a/mysql-test/suite/perfschema/r/read_only.result
+++ b/mysql-test/suite/perfschema/r/read_only.result
@@ -3,7 +3,7 @@ set @start_read_only= @@global.read_only;
create user pfsuser@localhost;
grant SELECT, UPDATE on performance_schema.* to pfsuser@localhost;
flush privileges;
-connect con1, localhost, pfsuser, , test;
+connect con1, localhost, pfsuser, ,"*NO-ONE*";
connection default;
set global read_only=0;
connection con1;
@@ -35,7 +35,7 @@ connection default;
grant READ_ONLY ADMIN on *.* to pfsuser@localhost;
flush privileges;
disconnect con1;
-connect con1, localhost, pfsuser, , test;
+connect con1, localhost, pfsuser, ,"*NO-ONE*";
select @@global.read_only;
@@global.read_only
1
diff --git a/mysql-test/suite/perfschema/t/connect_attrs.test b/mysql-test/suite/perfschema/t/connect_attrs.test
index c703badef85..2d2c2ce266e 100644
--- a/mysql-test/suite/perfschema/t/connect_attrs.test
+++ b/mysql-test/suite/perfschema/t/connect_attrs.test
@@ -45,7 +45,7 @@ SELECT COUNT(DISTINCT PROCESSLIST_ID)
CREATE USER wl5924@localhost;
-connect(non_privileged_user,localhost,wl5924,,test);
+connect(non_privileged_user,localhost,wl5924,,"*NO-ONE*");
connection default;
--echo # must return 1
diff --git a/mysql-test/suite/perfschema/t/global_read_lock.test b/mysql-test/suite/perfschema/t/global_read_lock.test
index 4217de0d723..430d6eed5dc 100644
--- a/mysql-test/suite/perfschema/t/global_read_lock.test
+++ b/mysql-test/suite/perfschema/t/global_read_lock.test
@@ -15,7 +15,7 @@ create user pfsuser@localhost;
grant SELECT, UPDATE, LOCK TABLES on performance_schema.* to pfsuser@localhost;
flush privileges;
-connect (con1, localhost, pfsuser, , test);
+connect (con1, localhost, pfsuser, ,"*NO-ONE*");
lock tables performance_schema.setup_instruments read;
--disable_result_log
diff --git a/mysql-test/suite/perfschema/t/grant.test b/mysql-test/suite/perfschema/t/grant.test
index 446965dfe9d..9a52a17223b 100644
--- a/mysql-test/suite/perfschema/t/grant.test
+++ b/mysql-test/suite/perfschema/t/grant.test
@@ -4,7 +4,7 @@
# MDEV-22884 Assertion `grant_table || grant_table_role' failed on perfschema
#
create user a@localhost;
-connect a,localhost,a;
+connect a,localhost,a,,"*NO-ONE*";
select * from performance_schema.global_status where variable_name='b';
connection default;
disconnect a;
diff --git a/mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test b/mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test
index 4c68d3af51e..69b3cb6ac94 100644
--- a/mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test
+++ b/mysql-test/suite/perfschema/t/hostcache_ipv4_auth_ed25519.test
@@ -43,7 +43,7 @@ error ER_ACCESS_DENIED_ERROR;
connect con1, 127.0.0.1, plug2,bar,,$MASTER_MYPORT;
source ../include/hostcache_dump.inc;
-connect con1, 127.0.0.1, plug2,foo,,$MASTER_MYPORT;
+connect con1, 127.0.0.1, plug2,foo,"*NO-ONE*",$MASTER_MYPORT;
select current_user();
disconnect con1;
connection default;
diff --git a/mysql-test/suite/perfschema/t/privilege.test b/mysql-test/suite/perfschema/t/privilege.test
index a0af41e0372..06e7cdf0cae 100644
--- a/mysql-test/suite/perfschema/t/privilege.test
+++ b/mysql-test/suite/perfschema/t/privilege.test
@@ -8,6 +8,9 @@ show grants;
create user 'pfs_user_1'@localhost;
create user 'pfs_user_2'@localhost;
create user 'pfs_user_3'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_1'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_2'@localhost;
+grant SELECT,INSERT,UPDATE,DELETE,DROP,CREATE on test.* to 'pfs_user_3'@localhost;
grant ALL on *.* to 'pfs_user_1'@localhost with GRANT OPTION;
# Test denied privileges on performance_schema.*
@@ -228,7 +231,7 @@ flush privileges;
--echo # Setup user
CREATE user pfs_user_4;
---connect (pfs_user_4, localhost, pfs_user_4, , )
+--connect (pfs_user_4, localhost, pfs_user_4, ,"*NO-ONE*")
--echo #
--echo # WL#4818, NFS4: Normal user does not have access to view data
diff --git a/mysql-test/suite/perfschema/t/read_only.test b/mysql-test/suite/perfschema/t/read_only.test
index 2d8e41595d1..4cbaad0de6b 100644
--- a/mysql-test/suite/perfschema/t/read_only.test
+++ b/mysql-test/suite/perfschema/t/read_only.test
@@ -16,7 +16,7 @@ create user pfsuser@localhost;
grant SELECT, UPDATE on performance_schema.* to pfsuser@localhost;
flush privileges;
-connect (con1, localhost, pfsuser, , test);
+connect (con1, localhost, pfsuser, ,"*NO-ONE*");
connection default;
@@ -55,7 +55,7 @@ grant READ_ONLY ADMIN on *.* to pfsuser@localhost;
flush privileges;
disconnect con1;
-connect (con1, localhost, pfsuser, , test);
+connect (con1, localhost, pfsuser, ,"*NO-ONE*");
select @@global.read_only;
show grants;
View Lorry Controller Status