linux系统下MySQL表名区分大小写问题

因为Linux环境下的MySQL数据库的表名默认是区分大小写的，可以查看Linux上的MySQL的配置文件/etc/my.cnf:

[root@VM_219_131_centos tomcat7]# 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

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@VM_219_131_centos tomcat7]#

 

如果要使用数据库表名不区分大小写的话，就需要在[mysqld]下面添加一行配置，即 lower_case_table_names=1:

[root@VM_219_131_centos tomcat7]# vi /etc/my.cnf
[mysqld]
lower_case_table_names=1
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

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

修改完配置之后，一定要重启数据库：

service mysqld restart