安装mysql 1042错误

90 阅读 0 评论 60 点赞

我是靠谱客的博主称心老鼠，最近开发中收集的这篇文章主要介绍安装mysql 1042错误，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

日志：

Beginning configuration step: Writing 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.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Starting Server
Attempting to start service MySQL80...
Failed to start service MySQL80.
Waiting until a connection to MySQL Server 8.0.11 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...
......
Retry 10: 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.
Failed to connect to MySQL Server 8.0.11 after 10 attempts.
Ended configuration step: Starting Server

重试10:正在尝试用用户根目录连接mysql@localhost:3306，但没有密码…

MySQL错误1042:无法连接到任何指定的MySQL主机。

10次尝试后未能连接到MySQL Server 8.0.11。

结束配置步骤：启动服务器

没搞懂什么问题，只有把服务改成本地系统账户，就不报错了。