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.查询结果