Linux环境下修改MySQL数据库对表名大小写不敏感

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)