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