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
上一篇: Glide的使用解析
推荐阅读
-
MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error
-
在node1节点上安装mysql,启动Hive时报错问题解决办法
-
eclipse 3.5.2 启动报错 jvm terminated exit code = -1
-
解决MAC上启动mongod报错exiting with code 1的问题
-
Win10电脑中启动超猎都市游戏报错vulkan-1.dll怎么办?
-
lower_case_table_names=1 启动报错 mysql8.0
-
rhel 5.10下安装oracle 11g R1 启动数据库报错问题解决方法
-
VNC启动报错问题‘testdb:1 is taken because of’解决
-
MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error
-
在node1节点上安装mysql,启动Hive时报错问题解决办法