Linux系统中MySQL对数据库名称和表名是大小写敏感的，这就导致了一些麻烦，虽然已经建立了表和数据，但因为大小写导致无法找到表。
MySQL数据库对表名大小写不敏感的设置方法如下：
1、查看MySQL配置信息
mysql> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_table_names | 0 |
+------------------------+-------+
1 row in set (0.00 sec)
2、修改MySQL配置信息
[root@test-121 ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default-storage-engine=InnoDB
lower_case_table_names=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=utf-8
3、重启MySQL服务
service mysqld restart
4、查看MySQL配置信息
mysql> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_table_names | 1 |
+------------------------+-------+
1 row in set (0.00 sec)