1# 2# only global 3# 4select @@global.init_file; 5--error ER_INCORRECT_GLOBAL_LOCAL_VAR 6select @@session.init_file; 7show global variables like 'init_file'; 8show session variables like 'init_file'; 9select * from information_schema.global_variables where variable_name='init_file'; 10select * from information_schema.session_variables where variable_name='init_file'; 11 12# 13# show that it's read-only 14# 15--error ER_INCORRECT_GLOBAL_LOCAL_VAR 16set global init_file=1; 17--error ER_INCORRECT_GLOBAL_LOCAL_VAR 18set session init_file=1; 19 20