mysql安装时卡在starting server的解决方法

在安装MySQL8.0.13的最后一步，配置启动MySQL服务的时候，MySQL启动失败，查看Log日志错误如下：Attempting to start service MySQL80...Failed to start service MySQL80.Waiting until a connection to MySQL Server 8.0.13 can be established (wit

Program_xww

3974人浏览 · 2021-11-20 17:52:38

Program_xww · 2021-11-20 17:52:38 发布

在安装MySQL8.0.13的最后一步，配置启动MySQL服务的时候，MySQL启动失败，查看Log日志错误如下：

Attempting to start service MySQL80...
Failed to start service MySQL80.
Waiting until a connection to MySQL Server 8.0.13 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
MySQL error 1042: Unable to connect to any of the specified MySQL hosts.
Waiting 3 seconds before the next connection attempt...

故障揣测
由于新装的操作系统，之前出现过权限不足的提示，故首先定位故障为权限问题。由于MySQL80服务在计算机管理->服务里面显示户别为：网络服务。

解决步骤
所以为提高网络服务权限，需将网络服务添加到管理员组，步骤如下：

计算机->管理->本地用户和组->组双击：

双击Administrators
点击添加
点击高级
把 NETWORK SERVICE添加到Administrators组