无法在本地计算机上启动MySQL80服务

j8ag8udp  于 2023-05-16  发布在  Mysql
关注(0)|答案(4)|浏览(348)

我正在安装MySQL8.0.18。在应用配置时,每当我按下execute时,它都会在starting the server上停止,并且不会配置它。在日志选项卡中,它说;

Beginning configuration step: Starting the server
Attempting to start service MySQL80...
Failed to start service MySQL80.
Waiting until a connection to MySQL Server 8.0.18 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.
Waiting 5 seconds before the next connection attempt...    
Retry 2: 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.
Waiting 5 seconds before the next connection attempt...
Retry 3: 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.
Waiting 5 seconds before the next connection attempt...
Retry 4: 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.
Waiting 5 seconds before the next connection attempt...
Retry 5: 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.
Waiting 5 seconds before the next connection attempt...
Retry 6: 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.
Waiting 5 seconds before the next connection attempt...
Retry 7: 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.
Waiting 5 seconds before the next connection attempt...
Retry 8: 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.
Waiting 5 seconds before the next connection attempt...
Retry 9: 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.
Waiting 5 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.
Failed to connect to MySQL Server 8.0.18 after 10 attempts.
Ended configuration step: Starting the server

我不知道是否是位置错误或其他原因,因为我将设置保存在E:\setups\mySQL\setup中。它给出了快照中显示的错误。我试着根据这里的第一个答案来解决它,但它似乎没有帮助。

我试图重新安装它,但它仍然给出了同样的错误不知何故。我该怎么办?

eivnm1vs

eivnm1vs1#

好吧,MySQL中的错误2只是由于文件丢失或位置错误而引起的。您尝试运行的服务的路径可能错误或丢失。

下面是一些相同问题的参考

可能的解决方案:

检查MySQL80服务的路径是否正确,所有文件是否具有适当的执行和网络权限。如果没有任何效果,可以使用不同版本查看它是否在那里工作,如果它在新版本报告bug

cwtwac6a

cwtwac6a2#

我不知道,如果我们有相同的Mysql程序设计,我使用的是最新版本8.0.26。试试这个:打开你的sql编辑器->转到屏幕左侧的导航器->内部-示例-选择 * 启动/关闭 *。
然后点击-启动服务器-按钮。
如果没有工作,或者程序崩溃,转到Windows搜索工具,键入-服务-然后搜索Mysql服务,然后单击-开始-它应该被关闭。
希望这个工作…

hrysbysz

hrysbysz3#

我也遇到了同样的问题。我是这样解决的。

  1. Win+R
    1.输入“services.msc”,然后单击“Enter”
    1.找到MySQL服务,右键单击,选择“属性”选项
    1.选择“登录”选项,然后选择“本地系统帐户”结束我希望这能解决你的问题。
toiithl6

toiithl64#

打开C:\ProgramData\MySQL。您将找到已存档的my.ini文件的列表。使用一个替换当前my.ini文件位于“C:\ProgramData\MySQL\MySQL Server xx.0”

相关问题