Debian Codegraph @

mysql-test/suite/roles/password.result

raw
1 set sql_mode='';
2 create role r1;
3 grant select on *.* to r1 identified by 'foobar';
4 drop user r1;
5 grant select on *.* to r1 identified by '';
6 drop user r1;
7 grant select on mysql.user to r1 identified by password '00000000000000000000000000000000000000000';
8 drop user r1;
9 grant select on *.* to r1 identified via plugin;
10 ERROR HY000: Plugin 'plugin' is not loaded
11 grant select on mysql.user to r1 identified via plugin using 'param';
12 ERROR HY000: Plugin 'plugin' is not loaded
13 grant select on *.* to r1 require subject 'foobar';
14 drop user r1;
15 grant select on mysql.user to r1 require issuer 'foobar';
16 drop user r1;
17 grant select on *.* to r1 require cipher 'foobar';
18 drop user r1;
19 grant select on mysql.user to r1 require ssl;
20 drop user r1;
21 grant select on *.* to r1 require x509;
22 drop user r1;
23 grant select on mysql.user to r1 require none;
24 drop user r1;
25 grant select on *.* to r1 with max_queries_per_hour 10;
26 drop user r1;
27 grant select on mysql.user to r1 with max_updates_per_hour 10;
28 drop user r1;
29 grant select on *.* to r1 with max_connections_per_hour 10;
30 drop user r1;
31 grant select on mysql.user to r1 with max_user_connections 10;
32 drop user r1;
33 set password for r1 = '00000000000000000000000000000000000000000';
34 ERROR 28000: Can't find any matching row in the user table
35 drop role r1;