欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

lower_case_table_names=1 启动报错 mysql8.0

程序员文章站 2022-03-26 13:24:41
在安装了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 245672019-01-28T13:24:25.339412+08:00 1 [ERROR] [MY-01108...

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

相关标签: bug遇到的坑