直接设置:
mysql> set lower_case_table_names=1;ERROR 1238 (HY000): Variable 'lower_case_table_names' is a read only variable
在/etc/my.cnf的[mysqld]下增加
lower_case_table_names = 1