MySQL8.0.2启动报Different lower_case_table_names settings for server ('1') and data dictionary ('0').

记录在安装了MySQL 8.0.20之后，初始化的时候在my.cnf里设置了lower_case_table_names=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

详见

https://bugs.mysql.com/bug.php?id=90695