1SET @start_global_value = @@global.innodb_encrypt_tables; 2select @@global.innodb_encrypt_tables; 3@@global.innodb_encrypt_tables 4OFF 5select @@session.innodb_encrypt_tables; 6ERROR HY000: Variable 'innodb_encrypt_tables' is a GLOBAL variable 7show global variables like 'innodb_encrypt_tables'; 8Variable_name Value 9innodb_encrypt_tables OFF 10show session variables like 'innodb_encrypt_tables'; 11Variable_name Value 12innodb_encrypt_tables OFF 13select * from information_schema.global_variables 14where variable_name='innodb_encrypt_tables'; 15VARIABLE_NAME VARIABLE_VALUE 16INNODB_ENCRYPT_TABLES OFF 17select * from information_schema.session_variables 18where variable_name='innodb_encrypt_tables'; 19VARIABLE_NAME VARIABLE_VALUE 20INNODB_ENCRYPT_TABLES OFF 21set global innodb_encrypt_tables=ON; 22ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'ON' 23show warnings; 24Level Code Message 25Warning 138 InnoDB: cannot enable encryption, encryption plugin is not available 26Error 1231 Variable 'innodb_encrypt_tables' can't be set to the value of 'ON' 27select @@global.innodb_encrypt_tables; 28@@global.innodb_encrypt_tables 29OFF 30set global innodb_encrypt_tables=OFF; 31select @@global.innodb_encrypt_tables; 32@@global.innodb_encrypt_tables 33OFF 34set global innodb_encrypt_tables=1; 35ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of '1' 36select @@global.innodb_encrypt_tables; 37@@global.innodb_encrypt_tables 38OFF 39set session innodb_encrypt_tables=1; 40ERROR HY000: Variable 'innodb_encrypt_tables' is a GLOBAL variable and should be set with SET GLOBAL 41set global innodb_encrypt_tables=1.1; 42ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables' 43set global innodb_encrypt_tables=1e1; 44ERROR 42000: Incorrect argument type to variable 'innodb_encrypt_tables' 45set global innodb_encrypt_tables="foo"; 46ERROR 42000: Variable 'innodb_encrypt_tables' can't be set to the value of 'foo' 47SET @@global.innodb_encrypt_tables = @start_global_value; 48