From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/roles/password.result | 35 ++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 mysql-test/suite/roles/password.result (limited to 'mysql-test/suite/roles/password.result') diff --git a/mysql-test/suite/roles/password.result b/mysql-test/suite/roles/password.result new file mode 100644 index 00000000..2d54db2c --- /dev/null +++ b/mysql-test/suite/roles/password.result @@ -0,0 +1,35 @@ +set sql_mode=''; +create role r1; +grant select on *.* to r1 identified by 'foobar'; +drop user r1; +grant select on *.* to r1 identified by ''; +drop user r1; +grant select on mysql.user to r1 identified by password '00000000000000000000000000000000000000000'; +drop user r1; +grant select on *.* to r1 identified via plugin; +ERROR HY000: Plugin 'plugin' is not loaded +grant select on mysql.user to r1 identified via plugin using 'param'; +ERROR HY000: Plugin 'plugin' is not loaded +grant select on *.* to r1 require subject 'foobar'; +drop user r1; +grant select on mysql.user to r1 require issuer 'foobar'; +drop user r1; +grant select on *.* to r1 require cipher 'foobar'; +drop user r1; +grant select on mysql.user to r1 require ssl; +drop user r1; +grant select on *.* to r1 require x509; +drop user r1; +grant select on mysql.user to r1 require none; +drop user r1; +grant select on *.* to r1 with max_queries_per_hour 10; +drop user r1; +grant select on mysql.user to r1 with max_updates_per_hour 10; +drop user r1; +grant select on *.* to r1 with max_connections_per_hour 10; +drop user r1; +grant select on mysql.user to r1 with max_user_connections 10; +drop user r1; +set password for r1 = '00000000000000000000000000000000000000000'; +ERROR 28000: Can't find any matching row in the user table +drop role r1; -- cgit v1.2.3