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


2019-01-28T13:24:24.919463+08:000[System][MY-010116][Server]/usr/local/mysql/bin/mysqld(mysqld8.0.14)startingasprocess245672019-01-28T13:24:25.339412+08:001[ERROR][MY-011087][Server]Differentlower_case_table_namessettingsforserver('1')anddatadictionary('0').2019-01-28T13:24:25.339709+08:000[ERROR][MY-010020][Server]DataDictionaryinitializationfailed.2019-01-28T13:24:25.339903+08:000[ERROR][MY-010119][Server]Aborting2019-01-28T13:24:26.660278+08:000[System][MY-010910][Server]/usr/local/mysql/bin/mysqld:Shutdowncomplete(mysqld8.0.14)MySQLCommunityServer-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才有效，比如：

--initialize--lower-case-table-names=1


详见

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