1SET @@GLOBAL.innodb_encrypt_tables="OFF";
2SELECT @@GLOBAL.innodb_encrypt_tables;
3@@GLOBAL.innodb_encrypt_tables
4OFF
5SET SESSION innodb_encrypt_tables="ON";
6ERROR HY000: Variable 'innodb_encrypt_tables' is a GLOBAL variable and should be set with SET GLOBAL
7SET GLOBAL innodb_encrypt_tables="ON";
8SELECT @@GLOBAL.innodb_encrypt_tables;
9@@GLOBAL.innodb_encrypt_tables
10ON
11SET GLOBAL innodb_encrypt_tables="OFF";
12SELECT @@GLOBAL.innodb_encrypt_tables;
13@@GLOBAL.innodb_encrypt_tables
14OFF
15SET GLOBAL innodb_encrypt_tables="FORCE";
16SELECT @@GLOBAL.innodb_encrypt_tables;
17@@GLOBAL.innodb_encrypt_tables
18FORCE
19SET GLOBAL innodb_encrypt_tables=1.1;
20ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables'
21SET GLOBAL innodb_encrypt_tables=1e1;
22ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables'
23SET GLOBAL innodb_encrypt_tables=NULL;
24ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'NULL'
25SET GLOBAL innodb_encrypt_tables='foo';
26ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'foo'
27SELECT @@GLOBAL.innodb_encrypt_tables;
28@@GLOBAL.innodb_encrypt_tables
29FORCE
30SET @@GLOBAL.innodb_encrypt_tables="OFF";
31