当前位置:   article > 正文

不吐不快:mysql安装报错unknown variable ‘mysqlx_port=0.0‘._innodb: creating foreign key constraint system tab

innodb: creating foreign key constraint system tables. unknown variable 'mys

安装mysql,安装失败,查看报错log

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 MySQL57 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.
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)

Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.44...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
InnoDB: New log files created, LSN=45790
InnoDB: Creating foreign key constraint system tables.
unknown variable 'mysqlx_port=0.0'
Aborting
Process for mysqld, with ID 5572, was run successfully and exited with code 1.
Failed to start process for MySQL Server 5.7.44.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)

注意:

1,安装包是刚从官网下的。

2,版本5.7.44.

最初以为是自己安装的选项有问题,没办法,重装系统,重新安装,特别百度安装过程,每一步小心选择。。。结果。。还是出错。

然后,百度报错信息。csdn给出很多解决方案。始终觉得不靠谱。

最后,发现,这些文章均发表于2024。怀疑新版本的安装包有问题。毅然决然,重做系统,把以前版本的安装包找出来。mysql-installer-community-5.7.39.0.msi。然后,啥问题也没有,顺利安装成功。耽误了我几个小时,重装系统3次。居然是这种问题.。

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/我家小花儿/article/detail/900484
推荐阅读
相关标签
  

闽ICP备14008679号