mysql 不区分大小写

show variables like ‘%case%‘

+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |       表示已经是支持忽略大小写了
+------------------------+-------+

修改  /etc/mysql/my.cnf

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
lower_case_table_names=1   

原文：http://www.cnblogs.com/sjj1022/p/7357195.html