mysql8设置表名大小写不敏感(lower_case_table_names=1)
mysql8更改Mysql 表的大小转换设置lower_case_table_names=1
试过设成0和2都没问题,就是无法设置成1.
查看MySQL官方文档,有记录:
lower_case_table_names can only be configured when initializing the server. Changing the lower_case_table_names setting after the server is initialized is prohibited.
只有在初始化的时候设置 lower_case_table_names=1才有效,比如:
--initialize --lower-case-table-names=1