The configuration for MySOL Server 8.0.39 has failed.（原因为 mysql-installer-community-8.0.36.0.msi 有缺陷）

1、The configuration for MySOL Server 8.0.39 has failed.。如图1

图1

2、查看日志，如下所示

Beginning configuration step: Starting the server and upgrading system tables (may take a long time)

Attempting to start service MySQL80...
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) starting as process 15472
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
InnoDB initialization has started.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) starting as process 15472
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
InnoDB initialization has started.
InnoDB initialization has ended.
CA certificate ca.pem is self signed.
Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
unknown variable 'mysqlx_port=0.0'.
Aborting
InnoDB initialization has ended.
CA certificate ca.pem is self signed.
Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
unknown variable 'mysqlx_port=0.0'.
Aborting
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL...................................
MySQL failed to start because of the following error(s):
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
unknown variable 'mysqlx_port=0.0'.
Aborting

只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。
Ended configuration step: Starting the server and upgrading system tables (may take a long time)

........................................................

3、编辑 C:\ProgramData\MySQL\MySQL Server 8.0\my.ini。

# The TCP/IP Port the MySQL Server X Protocol will listen on.
mysqlx_port=33060

4、右键 mysql-installer-community-8.0.36.0.msi 安装，MySOL Server ，点击 Reconfigure。如图2

图2

5、仍然报错，但是已经在报另外的错误了。Successfully started service MySQL80. 已结束配置步骤：启动服务器并升级系统表（可能需要很长时间）。如图3

图3

Beginning configuration step: Starting the server and upgrading system tables (may take a long time)

Attempting to start service MySQL80...
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) starting as process 18132
InnoDB initialization has started.
InnoDB initialization has ended.
CA certificate ca.pem is self signed.
Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
X Plugin ready for connections. Bind-address: '::' port: 33060
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.39'  socket: ''  port: 3306  MySQL Community Server - GPL.
Successfully started service MySQL80.
The upgrade of system tables did not complete successfully. Check for errors in the log.
Ended configuration step: Starting the server and upgrading system tables (may take a long time)

6、再次右键 mysql-installer-community-8.0.36.0.msi 安装，MySOL Server ，点击 Reconfigure。如图4

图4

7、The configuration step [Starting the server and upgrading system tables (may take a long time)] is taking longer than expected.It is advised to not cancel the configuration and wait.配置步骤 [启动服务器并升级系统表（可能需要很长时间）] 所花的时间比预期的要长。建议不要取消配置并等待。竟然整整等待了一个晚上加半个白天，真心吐血了。虽然期间可能有电脑休眠的缘故以及提示是否要取消的弹窗，没有来得及点击 Wait 按钮。如图5、图6

图5

图6

8、最终决定放弃，以管理员身份重新启动 MySQL Installer。卸载 MySQL Server 8.0.39 。如图7

图7

9、点击 Add 按钮，重新安装 ，Initializing database (may take a long time) 失败。如图8

图8

10、查看 Log，C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe：将值“0.0”设置为“mysqlx-port”时出错。插件“mysqlx”的解析选项失败。

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
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
确定。


Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
确定。


Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.
Granted permissions to the data directory.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.39...
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 --lower-case-table-names=1....
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) initializing of server in progress as process 17772
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
InnoDB initialization has started..
InnoDB initialization has ended..
unknown variable 'mysqlx_port=0.0'.
The newly created data directory C:\ProgramData\MySQL\MySQL Server 8.0\Data\ by --initialize is unusable. You can remove it.
Aborting.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
Process for mysqld, with ID 17772, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.39.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

........................................................................................................................

10、重复步骤 3，Back 后，再次 Execute。不再报错。Starting the server 失败，再次重复步骤 3，再次 Execute。仍然失败。如图9

图9

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Attempting to delete a Windows Firewall rule with command: netsh.exe advfirewall firewall delete rule name="Port 3306" protocol=TCP localport=3306

已删除 1 规则。
确定。


Adding a Windows Firewall rule for MySQL80 on port 3306.
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
确定。


Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
确定。


Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.
Granted permissions to the data directory.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Updating permissions for the data folder and related server files

Attempting to update the permissions for the data folder and related server files...
Found existing data directory, no need to initialize the database.
The data folder and related server files have already been updated.
Ended configuration step: Updating permissions for the data folder and related server files

Beginning configuration step: Starting the server

Attempting to start service MySQL80....
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) starting as process 17964
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
InnoDB initialization has started.
InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Failed to open optimizer cost constant tables
Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
CA certificate ca.pem is self signed.
Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
Failed to open optimizer cost constant tables
A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
unknown variable 'mysqlx_port=0.0'.
Aborting
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL..................................................
只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。
Ended configuration step: Starting the server

..............................

11、决定使用系统自带的卸载功能，如图10、图11

图10

图11

12、卸载所有的 MySQL 相关的软件。如图12

图12

13、再次安装时，选择自定义。如图13

图13

14、皆选择 8.0.36 的版本。如图14

图14

15、仍然失败，如图15

图15

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
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
确定。


Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
确定。


Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.
Granted permissions to the data directory.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.36...
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 --lower-case-table-names=1...
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.36) initializing of server in progress as process 17052
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Error while setting value '0.0' to 'mysqlx-port'.
Parsing options for plugin 'mysqlx' failed.
InnoDB initialization has started.
InnoDB initialization has ended.
unknown variable 'mysqlx_port=0.0'.
The newly created data directory C:\ProgramData\MySQL\MySQL Server 8.0\Data\ by --initialize is unusable. You can remove it.
Aborting
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.36)  MySQL Community Server - GPL.
Process for mysqld, with ID 17052, was run successfully and exited with code 1.
Failed to start process for MySQL Server 8.0.36.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

16、参考：MySql installation database initialization error 。这是 8.0.11 安装程序中的一个错误。虽然错误有差异，我决定重新下载一个 MySQL Installer 最新版本 mysql-installer-community-8.0.39.0.msi。安装成功，不再报错。如图16

图16