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
mysql 不区分大小写
标签：nbsp etc 大小 system mysqld clu names strong table