lower_case_table_names=1 启动报错 mysql8.0

在安装了8.0.14之后，初始化的时候在my.cnf里设置了lower_case_table_names=1，安装好了之后，启动报错：

2019-01-28T13:24:24.919463+08:00 0 [System] [MY-010116] [Server]
/usr/local/mysql/bin/mysqld (mysqld 8.0.14) starting as process 24567
2019-01-28T13:24:25.339412+08:00 1 [ERROR] [MY-011087] [Server]
Different lower_case_table_names settings for server (‘1’) and data
dictionary (‘0’). 2019-01-28T13:24:25.339709+08:00 0 [ERROR]
[MY-010020] [Server] Data Dictionary initialization failed.
2019-01-28T13:24:25.339903+08:00 0 [ERROR] [MY-010119] [Server]
Aborting 2019-01-28T13:24:26.660278+08:00 0 [System] [MY-010910]
[Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld
8.0.14) MySQL Community Server - GPL.

查看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才有效，比如：

/usr/sbin/mysqld --initialize --user=mysql --lower-case-table-names=1

本文地址：https://blog.csdn.net/qq_41688840/article/details/107457599