MYSQL 服务器在安装时失败

Question

更改登录到本地服务然后启动服务器时的屏幕截图: 1

这是日志:

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL57 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Initializing Database [if necessary]
Deleting Data folder shipped
Attempting to run MySQL Server with --Initialize-insecure
Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console
2017-04-15T06:26:24.188171Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-15T06:26:24.188171Z 0 [Warning] '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.
2017-04-15T06:26:29.144031Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-04-15T06:26:29.946540Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-04-15T06:26:30.159610Z 0 [ERROR] unknown variable 'innodbclustertypeselection=0.0'
2017-04-15T06:26:30.160610Z 0 [ERROR] Aborting

The attempt to initialize the database Failed
Ended configuration step: Initializing Database [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service

提供截图(在这个安装过程中我的防火墙和防御者被关闭了)

Answer 1

考虑到您在 Windows 上工作，请尝试以下操作。

如果不需要集群安装，则必须从 my.ini 文件中删除或注释集群配置变量，通常此文件位于 C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

my.ini 文件中注释的变量

...# Indicates how is the InnoDB Cluster configured as (Classic, Sandbox, Master or Slave).#innodbclustertypeselection=0.0# Indicates how is the InnoDB Cluster is/will be named.#innodbclustername=0.0# Indicates how many instances will the InnoDB cluster sandbox will have.#innodbclusterinstances=0.0# Holds the InnoDB Cluster Username.#innodbclusterusername=0.0# Indicates the InnoDB Cluster URI.#innodbclusteruri=0.0# Indicates the InnoDB Cluster Port.#innodbclusterport=0.0

希望对你有帮助