linux mysql区分大小写_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