时间戳

首页 > 解决方案 > 安装mysql出错

mysql - 安装mysql出错

问题描述

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-26T08:44:42.036600Z 0 [ERROR] [MY-011071] [Server] Unknown suffix '.' used for variable 'lower_case_table_names' (value '0.0')
2018-06-26T08:44:42.036600Z 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-26T08:44:42.036600Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-06-26T08:44:42.036600Z 0 [Note] [MY-010120] [Server] Binlog end
Process for mysqld, with ID 3232, 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 期间，我在日志中出现此错误。

标签： mysqlinstallation

解决方案

按照以下步骤解决：
- 回滚安装直到初始页面并选择删除 mysql 服务器
- 从添加/删除程序卸载 mysql 社区安装程序
- 重新启动
- 安装版本mysql-installer-web-community-5.7.22.1并在询问时选择更新。
- 完毕

推荐阅读