mysql> show variables like 'lower_case_table_names'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | lower_case_table_names | 0 | +------------------------+-------+ 1 row in set (0.01 sec)
mysql> set global lower_case_table_names=1; ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable mysql> set lower_case_table_names=1; ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable mysql>