本地计算机启动mysql服务停止,本地计算机上的MySQL服务启动然后停止

the MySQL service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs. Anyone can resolve this issue.Thanks Img

本地计算机上的MySQL服务启动然后停止。如果某些服务未被其他服务或程序使用，则会自动停止。任何人都可以解决这个问题。谢谢Img

6 个解决方案

#1

60

After installing it by mysqld --install. Try this mysqld --initialize. We got the same problem but it's now working.

由mysqld --install安装后。试试这个mysqld --initialize。我们遇到了同样的问题，但它现在正在运作。

#2

9

Also remember to give NETWORK SERVICE permission to the folder:

还记得给该文件夹提供NETWORK SERVICE权限：

Right-click Data folder

右键单击“数据”文件夹

Select Properties

选择属性

Select Security tab

选择安全选项卡

Click Advanced

单击高级

Click Change Permissions...

单击“更改权限”...

Click Add...

点击添加...

Type NETWORK SERVICE

键入NETWORK SERVICE

Click Check Names

单击“检查名称”

Click OK

单击确定

Select Full Control

选择完全控制

Click OK – four times

单击“确定” - 四次

Start MySQL service

启动MySQL服务

#3

2

In my case, I tried to open a DOS prompt and go to the MySQL bin\ directory and issue the below command:

在我的情况下，我尝试打开DOS提示符并转到MySQL bin \目录并发出以下命令：

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --standalone --console

And it shows me I was missing the "C:\Program Files\MySQL\MySQL Server 5.0\Uploads" folder; I built one and problem solved.

它告诉我，我错过了“C：\ Program Files \ MySQL \ MySQL Server 5.0 \ Uploads”文件夹;我建了一个，问题解决了。

#4

0

In my case, mysqld was starting and stopping with no error message. I needed to open command prompt using "Run as Administrator", and then run mysqld.

在我的情况下，mysqld启动并停止，没有错误消息。我需要使用“以管理员身份运行”打开命令提示符，然后运行mysqld。

I am only doing this for temporary development. I would not recommend running MySQL as an administrator in any case.

我只是为了临时开发而这样做。在任何情况下，我都不建议将MySQL作为管理员运行。

This was the final step after the above troubleshooting.

这是上述故障排除后的最后一步。

#5

0

Rename or delete the folder under,

重命名或删除下面的文件夹，

C:\ProgramData\MySQL\MySQL Server 5.7

C：\ ProgramData \ MySQL \ MySQL Server 5.7

folder name change as per your MYSQL version number.

文件夹名称根据您的MYSQL版本号更改。

#6

0

mysqld --initialize

mysqld --initialize

Run the above after the install command. Then try to start the service - that should work.

在install命令之后运行上面的命令。然后尝试启动服务 - 这应该工作。