Debian Codegraph @

mysql-test/suite/perfschema/r/read_only.result

raw
1 use performance_schema;
2 set @start_read_only= @@global.read_only;
3 create user pfsuser@localhost;
4 grant SELECT, UPDATE on performance_schema.* to pfsuser@localhost;
5 flush privileges;
6 connect con1, localhost, pfsuser, ,"*NO-ONE*";
7 connection default;
8 set global read_only=0;
9 connection con1;
10 select @@global.read_only;
11 @@global.read_only
12 0
13 show grants;
14 Grants for pfsuser@localhost
15 GRANT USAGE ON *.* TO `pfsuser`@`localhost`
16 GRANT SELECT, UPDATE ON `performance_schema`.* TO `pfsuser`@`localhost`
17 # Update on perf_schema is allowed in read_only mode.
18 select * from performance_schema.setup_instruments;
19 update performance_schema.setup_instruments set enabled='NO';
20 update performance_schema.setup_instruments set enabled='YES';
21 connection default;
22 set global read_only=1;
23 connection con1;
24 select @@global.read_only;
25 @@global.read_only
26 1
27 show grants;
28 Grants for pfsuser@localhost
29 GRANT USAGE ON *.* TO `pfsuser`@`localhost`
30 GRANT SELECT, UPDATE ON `performance_schema`.* TO `pfsuser`@`localhost`
31 select * from performance_schema.setup_instruments;
32 update performance_schema.setup_instruments set enabled='NO';
33 update performance_schema.setup_instruments set enabled='YES';
34 connection default;
35 grant READ_ONLY ADMIN on *.* to pfsuser@localhost;
36 flush privileges;
37 disconnect con1;
38 connect con1, localhost, pfsuser, ,"*NO-ONE*";
39 select @@global.read_only;
40 @@global.read_only
41 1
42 show grants;
43 Grants for pfsuser@localhost
44 GRANT READ_ONLY ADMIN ON *.* TO `pfsuser`@`localhost`
45 GRANT SELECT, UPDATE ON `performance_schema`.* TO `pfsuser`@`localhost`
46 select * from performance_schema.setup_instruments;
47 update performance_schema.setup_instruments set enabled='NO';
48 update performance_schema.setup_instruments set enabled='YES';
49 disconnect con1;
50 connection default;
51 set global read_only= @start_read_only;
52 drop user pfsuser@localhost;
53 flush privileges;