安装mysql 1042错误

时间:2024-05-19 20:01:42

安装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 [email protected]: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 [email protected]: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:正在尝试用用户根目录连接[email protected]:3306,但没有密码…

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

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

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

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

 

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

安装mysql 1042错误