Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_encryption.result

raw
1 SELECT COUNT(@@GLOBAL.binlog_encryption);
2 COUNT(@@GLOBAL.binlog_encryption)
3 1
4 SELECT COUNT(@@SESSION.binlog_encryption);
5 ERROR HY000: Variable 'binlog_encryption' is a GLOBAL variable
6 SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_encryption';
7 VARIABLE_NAME
8 binlog_encryption
9 SELECT VARIABLE_NAME FROM performance_schema.session_variables WHERE VARIABLE_NAME='binlog_encryption';
10 VARIABLE_NAME
11 binlog_encryption
12 SET GLOBAL binlog_encryption= ON;
13 include/assert.inc ['binlog_encryption is a dynamic variable']
14 SET GLOBAL binlog_encryption= OFF;
15 include/assert.inc ['binlog_encryption should be OFF']
16 SET GLOBAL binlog_encryption= ON;
17 include/assert.inc ['binlog_encryption should be ON']
18 SET GLOBAL binlog_encryption= 0;
19 include/assert.inc ['binlog_encryption should be OFF']
20 SET GLOBAL binlog_encryption= 1;
21 include/assert.inc ['binlog_encryption should be ON']
22 SET GLOBAL binlog_encryption= DEFAULT;
23 include/assert.inc ['binlog_encryption should be OFF']
24 SET GLOBAL binlog_encryption= NULL;
25 ERROR 42000: Variable 'binlog_encryption' can't be set to the value of 'NULL'
26 SET GLOBAL binlog_encryption= '';
27 ERROR 42000: Variable 'binlog_encryption' can't be set to the value of ''
28 SET GLOBAL binlog_encryption= -1;
29 ERROR 42000: Variable 'binlog_encryption' can't be set to the value of '-1'
30 SET GLOBAL binlog_encryption= 1.0;
31 ERROR 42000: Incorrect argument type to variable 'binlog_encryption'
32 SET GLOBAL binlog_encryption= 'GARBAGE';
33 ERROR 42000: Variable 'binlog_encryption' can't be set to the value of 'GARBAGE'
34 SET GLOBAL binlog_encryption= 2;
35 ERROR 42000: Variable 'binlog_encryption' can't be set to the value of '2'
36 Expect value still set to "OFF"
37 SELECT @@global.binlog_encryption;
38 @@global.binlog_encryption
39 0
40 CREATE USER user1;
41 SET GLOBAL binlog_encryption=ON;
42 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
43 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
44 ERROR 42000: Access denied; you need (at least one of) the SUPER or BINLOG_ENCRYPTION_ADMIN privilege(s) for this operation
45 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
46 SET GLOBAL binlog_encryption=ON;
47 ERROR 42000: Access denied; you need (at least one of) the SUPER or BINLOG_ENCRYPTION_ADMIN privilege(s) for this operation
48 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
49 ERROR 42000: Access denied; you need (at least one of) the SUPER or BINLOG_ENCRYPTION_ADMIN privilege(s) for this operation
50 GRANT BINLOG_ENCRYPTION_ADMIN ON *.* TO user1@'%';
51 SET GLOBAL binlog_encryption=ON;
52 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
53 REVOKE SYSTEM_VARIABLES_ADMIN ON *.* FROM user1@'%';
54 ALTER INSTANCE ROTATE BINLOG MASTER KEY;
55 SET GLOBAL binlog_encryption=OFF;
56 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
57 REVOKE BINLOG_ENCRYPTION_ADMIN ON *.* FROM user1@'%';
58 DROP USER user1;