mysql安装 starting the server失败

starting the server 试了很多种方法都没成功555555  有没有大佬知道这是什么问题?

详细如下:

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...
Inherited permissions have been converted to explicit permissions.
Full control permissions granted to: NETWORK SERVICE.
Full control permissions granted to: Administrators.
Full control permissions granted to: CREATOR OWNER.
Full control permissions granted to: SYSTEM.
Access to the data directory is removed for the users group.
Permissions for the data folder and related server files are updated correctly.
Ended configuration step: Updating permissions for the data folder and related server files

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

Attempting to start service MySQL80...
I:\software\MySQL\bin\mysqld.exe (mysqld 8.0.35) starting as process 10884
InnoDB initialization has started..
InnoDB initialization has ended...
Server upgrade from '80034' to '80035' started...............
MySQL failed to start due to an unknown cause. Review the logs and the validity of the values in the options file for more details.
只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。
Ended configuration step: Starting the server and upgrading system tables (may take a long time)

........
Server upgrade from '80034' to '80035' completed..
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
I:\software\MySQL\bin\mysqld.exe: ready for connections. Version: '8.0.35'  socket: ''  port: 3306  MySQL Community Server - GPL.

附:刚开始一直是这个问题 尝试这篇文章mysql安装报错unknown variable ‘mysqlx_port=0.0‘._mysqlx-port=0.0-CSDN博客后服务可以启动了,变成了上面这个问题 

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...
Inherited permissions have been converted to explicit permissions.
Full control permissions granted to: NETWORK SERVICE.
Full control permissions granted to: Administrators.
Full control permissions granted to: CREATOR OWNER.
Full control permissions granted to: SYSTEM.
Access to the data directory is removed for the users group.
Permissions for the data folder and related server files are updated correctly.
Ended configuration step: Updating permissions for the data folder and related server files

Beginning configuration step: Starting the server

Attempting to start service MySQL80...
I:\software\MySQL\bin\mysqld.exe (mysqld 8.0.34) starting as process 9360
Unknown suffix '.' used for variable 'mysqlx-port' (value '0.0').
option 'mysqlx-port': unsigned value 0 adjusted to 1.
I:\software\MySQL\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
I:\software\MySQL\bin\mysqld.exe: Shutdown complete (mysqld 8.0.34)  MySQL Community Server - GPL.................
只有在任务处于完成状态(RanToCompletion、Faulted 或 Canceled)时才能释放它。
Ended configuration step: Starting the server

.

  • 20
    点赞
  • 22
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
### 回答1: 可能是由于以下原因导致MySQL启动失败: 1. MySQL配置文件中的错误。请检查my.cnf文件是否正确配置。 2. MySQL数据目录中的错误。请检查MySQL数据目录是否存在,并且MySQL用户是否有足够的权限访问该目录。 3. 端口冲突。请检查MySQL使用的端口是否被其他应用程序占用。 4. MySQL安装文件损坏。请重新下载MySQL安装文件并重新安装。 5. 系统资源不足。请检查系统资源是否足够,例如内存和磁盘空间。 您可以根据上述原因逐一排查,找到导致MySQL启动失败的原因并进行修复。 ### 回答2: MySQL是一个流行的数据库管理系统,许多网站和应用程序都依赖它来进行数据存储,如果在安装MySQL时遇到starting the server失败的错误,这可能会对网站或应用程序的正常运行产生影响。以下是一些可能导致这个问题的原因以及相应的解决方法: 1.端口占用:MySQL使用默认的端口3306进行通信,如果该端口被其他应用程序占用,就会导致MySQL启动失败。可以通过在命令行中输入“netstat -ano”查看是否存在占用3306端口的程序,然后杀掉该进程,或者修改MySQL的监听端口。 解决方法:在my.cnf配置文件中修改MySQL的监听端口。 2.数据文件损坏:MySQL在启动时需要读取数据文件,如果这些文件损坏或者不存在,MySQL就会启动失败。 解决方法:尝试修复数据文件或者删除数据文件并重新安装MySQL。 3.权限问题:MySQL需要将数据文件和日志文件写入磁盘,如果没有足够的权限,就会导致启动失败。 解决方法:检查目录和文件的权限,修改为MySQL用户可以写入的权限。 4.配置文件错误:MySQL的配置文件(my.cnf)可能存在错误,导致MySQL启动失败。 解决方法:检查my.cnf配置文件中的所有参数,确保没有书写错误。 5.内存不足:MySQL需要足够的内存才能启动,如果内存不足,就会导致启动失败。 解决方法:增加系统内存或者调整MySQL的配置,降低内存使用率。 综上所述,starting the server失败可能由多种原因导致,关键是查找问题的根本原因,然后采取相应的解决方法。如果无法自己解决,可以寻求专业人员的帮助。 ### 回答3: MySQL 是一种流行的开源关系型数据库管理系统,适用于各种不同类型的项目。然而,在进行 MySQL 安装时,某些用户可能会遇到 starting the server 失败的问题。以下是可能的原因及解决方法: 1. 端口被占用 在运行 MySQL 服务器之前,必须检查并确保 3306 端口未被占用。如果端口已经被其他进程占用,MySQL 无法启动。你可以使用以下命令检查占用端口的进程: ``` netstat -anp | grep 3306 ``` 如果在输出中看到 PID,则表示另一个进程正在使用此端口。你可以使用 kill 命令杀死 PID 并释放端口。可以用以下命令来杀死进程: ``` kill -9 PID ``` 2. 配置文件错误 MySQL 服务器需要正确的配置文件以启动。你可以检查 my.cnf 或 my.ini 文件中的配置选项,确保它们是正确的。如果配置文件中有错误,MySQL 将无法启动。可以使用以下命令检查文件中的错误: ``` mysqld --verbose --help ``` 3. 数据文件损坏 如果 MySQL 服务器在上次运行时异常关闭,则数据文件可能会损坏。当尝试启动服务器时,将无法读取这些文件并启动服务器。为了解决此问题,可以使用以下命令修复损坏的数据文件: ``` mysqlcheck -r database_name ``` 4. 没有足够的权限 如果 MySQL 服务器在尝试启动时没有足够的权限,则无法启动。在这种情况下,可以使用以下命令更改 MySQL 文件夹的所有者和组: ``` sudo chown -R mysql:mysql /usr/local/mysql/ ``` 最后,如果您仍然无法解决 starting the server 失败的问题,请尝试从 MySQL 官方网站重新下载 MySQL 安装程序,并重新安装 MySQL 服务器。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值