Debian Codegraph @

mysql-test/suite/innodb/r/innodb_open_files_priv.result

raw
1 SET @start_global_value = @@GLOBAL.innodb_open_files;
2 SELECT @start_global_value;
3 @start_global_value
4 4000
5 SHOW STATUS LIKE 'SYSTEM_VARIABLES_ADMIN';
6 Variable_name Value
7 SELECT * FROM performance_schema.global_status WHERE variable_name like 'SYSTEM_VARIABLES_ADMIN';
8 VARIABLE_NAME VARIABLE_VALUE
9 SELECT @@innodb_open_files;
10 @@innodb_open_files
11 4000
12 CREATE USER 'user1'@'localhost' IDENTIFIED BY '123';
13 GRANT SUPER ON *.* to 'user1'@'localhost';
14 Warnings:
15 Warning 1287 The SUPER privilege identifier is deprecated
16 SHOW GRANTS FOR 'user1'@'localhost';
17 Grants for user1@localhost
18 GRANT SUPER ON *.* TO `user1`@`localhost`
19 SELECT * FROM performance_schema.global_status WHERE variable_name like 'SYSTEM_VARIABLES_ADMIN';
20 VARIABLE_NAME VARIABLE_VALUE
21 SELECT @@innodb_open_files ;
22 @@innodb_open_files
23 4000
24 SELECT innodb_set_open_files_limit(10);
25 innodb_set_open_files_limit(10)
26 10
27 SELECT @@innodb_open_files ;
28 @@innodb_open_files
29 10
30 DROP USER 'user1'@'localhost';
31 CREATE USER 'user1'@'localhost' IDENTIFIED BY '123';
32 GRANT SYSTEM_VARIABLES_ADMIN ON *.* to 'user1'@'localhost';
33 SHOW GRANTS FOR 'user1'@'localhost';
34 Grants for user1@localhost
35 GRANT USAGE ON *.* TO `user1`@`localhost`
36 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO `user1`@`localhost`
37 SELECT * FROM performance_schema.global_status WHERE variable_name like 'SYSTEM_VARIABLES_ADMIN';
38 VARIABLE_NAME VARIABLE_VALUE
39 SELECT @@innodb_open_files ;
40 @@innodb_open_files
41 10
42 SELECT innodb_set_open_files_limit(2147483647);
43 innodb_set_open_files_limit(2147483647)
44 2147483647
45 SELECT @@innodb_open_files ;
46 @@innodb_open_files
47 2147483647
48 DROP USER 'user1'@'localhost';
49 CREATE USER 'user1'@'localhost' IDENTIFIED BY '123';
50 GRANT SUPER ON *.* to 'user1'@'localhost';
51 Warnings:
52 Warning 1287 The SUPER privilege identifier is deprecated
53 GRANT SYSTEM_VARIABLES_ADMIN ON *.* to 'user1'@'localhost';
54 SHOW GRANTS FOR 'user1'@'localhost';
55 Grants for user1@localhost
56 GRANT SUPER ON *.* TO `user1`@`localhost`
57 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO `user1`@`localhost`
58 SELECT * FROM performance_schema.global_status WHERE variable_name like 'SYSTEM_VARIABLES_ADMIN';
59 VARIABLE_NAME VARIABLE_VALUE
60 SELECT @@innodb_open_files ;
61 @@innodb_open_files
62 2147483647
63 SELECT innodb_set_open_files_limit(4000);
64 innodb_set_open_files_limit(4000)
65 4000
66 SELECT @@innodb_open_files ;
67 @@innodb_open_files
68 4000
69 DROP USER 'user1'@'localhost';
70 CREATE USER 'user1'@'localhost' IDENTIFIED BY '123';
71 GRANT CREATE, SELECT, UPDATE, DELETE ON *.* TO 'user1'@'localhost';
72 SHOW GRANTS FOR 'user1'@'localhost';
73 Grants for user1@localhost
74 GRANT SELECT, UPDATE, DELETE, CREATE ON *.* TO `user1`@`localhost`
75 SELECT * FROM performance_schema.global_status WHERE variable_name like 'SYSTEM_VARIABLES_ADMIN';
76 VARIABLE_NAME VARIABLE_VALUE
77 SELECT @@innodb_open_files ;
78 @@innodb_open_files
79 4000
80 SELECT innodb_set_open_files_limit(6000);
81 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
82 SELECT @@innodb_open_files ;
83 @@innodb_open_files
84 4000
85 DROP USER 'user1'@'localhost';
86 SELECT innodb_set_open_files_limit(@start_global_value);
87 innodb_set_open_files_limit(@start_global_value)
88 4000
89 SELECT @@GLOBAL.innodb_open_files;
90 @@GLOBAL.innodb_open_files
91 4000