12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间:2024-12-03 12:11:22
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
在安装了8.0.14之后,初始化的时候在my.cnf里设置了lower_case_table_names=1,安装好了之后,启动报错:2019-01-28T13:24:24.919463+08:000[System][MY-010116][Server]/usr/local
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
在安装了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
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19