修改MySQL忽略大小写_修改mysql忽略大小写

mysql -p --1.登录mysql

show variables like "%case%";+------------------------+-------+| Variable_name | Value |+------------------------+-------+| lower_case_file_system | OFF | | lower_case_table_names | 0 | +------------------------+-------+2 rows in set (0.00 sec)   --2.查询结果

--3.ctrl+C 退出mysql

vim /etc/my.cnf  --4.编辑配置文件

[mysqld]

lower_case_table_names=1  --5.[mysqld]下新加的一行，意思就是忽略大小写

service mysql restart  --6.重启mysql服务

mysql -p --7.登录mysql

show variables like "%case%";+------------------------+-------+| Variable_name | Value |+------------------------+-------+| lower_case_file_system | OFF | | lower_case_table_names | 0 | +------------------------+-------+2 rows in set (0.00 sec)   --8.查询结果