mysql 8 初始化失败_mysql – 安装过程中出错 – 数据库初始化失败

在安装MySQLServer(Apply Configurations)的最后一步中,我收到一个奇怪的错误.我无法得到它.这是日志：

Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow

Ok.

Successfully added the Windows Firewall rule.

Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.

Granted permissions.

Adding new service

New service added

Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing Database

Attempting to run MySQL Server with --initialize-insecure option...

Starting process for MySQL Server 8.0.11...

Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on...

2018-06-25T21:06:16.705865Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')

2018-06-25T21:06:16.706023Z 0 [ERROR] [MY-011071] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'lower_case_table_names'

2018-06-25T21:06:16.706780Z 0 [ERROR] [MY-010119] [Server] Aborting

2018-06-25T21:06:16.707053Z 0 [Note] [MY-010120] [Server] Binlog end

Process for mysqld, with ID 6372, was run successfully and exited with code 1.

Failed to start process for MySQL Server 8.0.11.

Database initialization failed.

Ended configuration step: Initializing Database

这有什么不对？

解决方法:

刚刚遇到同样的问题,我不知道是什么导致数据库初始化失败.

但错误消失了

我使用’MySQL Installer – Community’完全卸载,重启我的电脑,然后尝试安装mysql服务器.

标签：mysql,server

来源： https://codeday.me/bug/20190910/1801455.html