• ADADADADAD

    MySQL8.0的坑之lower_case_table_names[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 12:11:22

    作者:文/会员上传

    简介:

    在安装了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

    MySQL8.0的坑之lower_case_table_names.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysql8.0坑之case