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、查看日志，如下所示
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | 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 15472Unknown 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 15472Unknown 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'.AbortingInnoDB 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'.AbortingC:\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。
1 2 | # 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
1 2 3 4 5 6 7 8 9 10 11 12 13 | 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 18132InnoDB 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: 33060C:\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
![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.配置步骤 [启动服务器并升级系统表（可能需要很长时间）] 所花的时间比预期的要长。建议不要取消配置并等待。竟然整整等待了一个晚上加半个白天，真心吐血了](https://www.shuijingwanwq.com/wp-content/uploads/2024/07/5-1.png)
图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”的解析选项失败。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | Beginning configuration step: Writing configuration fileSaving my.ini configuration file...Saved my.ini configuration file.Ended configuration step: Writing configuration fileBeginning configuration step: Updating Windows Firewall rulesAdding 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 rulesBeginning configuration step: Adjusting Windows serviceAttempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.Granted permissions to the data directory.Adding new serviceNew service addedEnded configuration step: Adjusting Windows serviceBeginning 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 17772Unknown 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 | Beginning configuration step: Writing configuration fileSaving my.ini configuration file...Saved my.ini configuration file.Ended configuration step: Writing configuration fileBeginning configuration step: Updating Windows Firewall rulesAttempting 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 rulesBeginning configuration step: Adjusting Windows serviceAttempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.Granted permissions to the data directory.Adding new serviceNew service addedEnded configuration step: Adjusting Windows serviceBeginning configuration step: Updating permissions for the data folder and related server filesAttempting 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 filesBeginning configuration step: Starting the serverAttempting to start service MySQL80....C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.39) starting as process 17964Unknown 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 existCould not open the mysql.plugin table. Please perform the MySQL upgrade procedure.Failed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesFailed to open optimizer cost constant tablesGtid 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 tablesA 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 existA 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'.AbortingC:\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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 | Beginning configuration step: Writing configuration fileSaving my.ini configuration file...Saved my.ini configuration file.Ended configuration step: Writing configuration fileBeginning configuration step: Updating Windows Firewall rulesAdding 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 rulesBeginning configuration step: Adjusting Windows serviceAttempting to grant the required filesystem permissions to the 'NT AUTHORITY\NetworkService' account.Granted permissions to the data directory.Adding new serviceNew service addedEnded configuration step: Adjusting Windows serviceBeginning 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 17052Unknown 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.AbortingC:\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
近期评论