1、查询MySQL是否设置了区分大小写
show variables like "%case%";
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | ON |
| lower_case_table_names | 0 |
+------------------------+-------+
lower_case_file_system:表示当前系统文件是否大小写敏感(ON为不敏感,OFF为敏感),只读参数,无法修改。
lower_case_table_names:0是区分大小写,1是不区分大小写,这里是表大小写不敏感
2.my.cnf文件中添加 lower_case_table_names = 1 ,重启mysql后生效
[mysqld]
lower_case_table_names = 1
3.重启
service mysqld stop
service mysqld start
重启查看是否生效
mysql> show variables like "%case%";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | ON |
| lower_case_table_names | 1 |
+------------------------+-------+