mysql5.7.35启动失败。The server quit without updating PID file

Question

centos7.2 编译安装的mysql5.7.35。初始化已经成功。

在启动的时候报错：
The server quit without updating PID file [FAILED]cal/mysql57/data/mysqld.pid).

查看log后发现报错是：
2021-12-08T09:25:44.854130Z 0 [ERROR] unknown variable 'lower_case_table_name=1'
2021-12-08T09:25:44.854130Z 0 [ERROR] Aborting

已经在配置文件里加了lower_case_table_names配置项。但提示是不对的参数 lower_case_table_name。文件夹等权限是都好的。
以下是my.cnf内容：

[client]
port                   = 3307
socket                 = /var/lib/mysql57/mysql.sock

[mysqld]
skip-grant-tables
basedir                = /usr/local/mysql57
datadir                = /usr/local/mysql57/data
socket                 = /var/lib/mysql57/mysql.sock
port                   = 3307
default-storage-engine = INNODB
character-set-server   = utf8
sql_mode               = "NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
#explicit_defaults_for_timestamp=true 
#user=root
lower_case_table_names = 1
key_buffer_size        = 16M
max_allowed_packet     = 8M


[mysqld_safe]
log-error              = /var/log/mysql57_error.log
pid-file               = /usr/local/mysql57/data/mysqld.pid
tmpdir                 = /tmp/mysql57

Answer 1

unknown variable 'lower_case_table_name=1'

的意思是不支持这个配置，把这个配置删除掉再启动试试

Answer 2

https://blog.csdn.net/eagle89...
看下这篇文章你是不是没有在初始化的时候加上这个参数。