问题描述：在f 内添加了如下命令行

lower_case_table_names=1 启动报错

tar xf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz在mysql-8.0.11-linux-glibc2.12-x86_64/目录内vim f[mysqld]basedir=/home/bes/mysql-8.0.11datadir=/home/bes/mysql-8.0.11/datasocket=/home/bes/mysql-8.0.11/mysql.socketcharacter-set-server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESlower_case_table_names=1[mysql]socket=/home/bes/mysql-8.0.11/mysql.socket[client]port=3306socket=/home/bes/mysql-8.0.11/mysql.sock初始化正常[bes@test162 mysql-8.0.11]$ ./bin/mysqld --initialize --user=bes --basedir=/home/bes/mysql-8.0.11/ --datadir=/home/bes/mysql-8.0.11/data/-09-02T10:14:51.918842Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.-09-02T10:14:51.919393Z 0 [System] [MY-013169] [Server] /home/bes/mysql-8.0.11/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 29903-09-02T10:14:56.004550Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 3euCoIoyd#:/-09-02T10:14:58.088418Z 0 [System] [MY-013170] [Server] /home/bes/mysql-8.0.11/bin/mysqld (mysqld 8.0.11) initializing of server has completed启动报错如下[bes@test162 bin]$ ./mysqld --defaults-file=../f --datadir=../data-09-02T10:17:02.007042Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.-09-02T10:17:02.007196Z 0 [System] [MY-010116] [Server] /home/bes/mysql-8.0.11/bin/mysqld (mysqld 8.0.11) starting as process 30019-09-02T10:17:02.936801Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('1') and data dictionary ('0').-09-02T10:17:02.938777Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.-09-02T10:17:02.939097Z 0 [ERROR] [MY-010119] [Server] Aborting-09-02T10:17:03.769453Z 0 [System] [MY-010910] [Server] /home/bes/mysql-8.0.11/bin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.

解决方案：

卸载现有环境，或者备份数据库

重新初始化用以下命令执行：[bes@test162 bin]$ ./mysqld --initialize --user=bes --basedir=/home/bes/mysql-8.0.11/ --datadir=/home/bes/mysql-8.0.11/data --lower_case_table_names=1-09-02T10:33:01.134249Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.-09-02T10:33:01.134420Z 0 [System] [MY-013169] [Server] /home/bes/mysql-8.0.11/bin/mysqld (mysqld 8.0.11) initializing of server in progress as process 30069-09-02T10:33:04.768022Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: XByW_4(k*cjl-09-02T10:33:06.649334Z 0 [System] [MY-013170] [Server] /home/bes/mysql-8.0.11/bin/mysqld (mysqld 8.0.11) initializing of server has completed##回显正常，初始化完成启动并检验[bes@test162 bin]$ nohup ./mysqld --defaults-file=../f --datadir=../data 2>&1 >/dev/null &[1] 30117[bes@test162 bin]$ nohup: 忽略输入重定向错误到标准输出端[bes@test162 bin]$ jobs[1]+ 运行中nohup ./mysqld --defaults-file=../f --datadir=../data 2>&1 > /dev/null &