mysql 不区分大小写

时间:2020-12-30 00:48:48

show variables like '%case%'

+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |       表示已经是支持忽略大小写了
+------------------------+-------+

修改  /etc/mysql/my.cnf

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
lower_case_table_names=1   

 

 

service mysql restart      重起数据库