在 Windows 7 上重启 mysql 服务器

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/12972434/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 15:14:58  来源:igfitidea点击:

restart mysql server on windows 7

mysqlwindows

提问by Norman

How do I restart MySQL on Windows 7?

如何在 Windows 7 上重新启动 MySQL?

I'm using HeidiSql as a front end and there's no option in there.

我使用 HeidiSql 作为前端,但没有选项。

The only other things I have is the MySQL 5.5 command line client.

我唯一拥有的其他东西是 MySQL 5.5 命令行客户端。

回答by ORION

Open the command prompt and enter the following commands:

打开命令提示符并输入以下命令:

net stop MySQL   
net start MySQL

the MySQL service name maybe changes based on the version you installed. In my situation, MySQL version is MySQL Server 5.7. So I use the following command

MySQL 服务名称可能会根据您安装的版本而更改。在我的情况下,MySQL 版本是 MySQL Server 5.7。所以我使用以下命令

net stop MySQL57   
net start MySQL57

回答by Frizz1977

open task manager, click in Service button and search MySql service, now you can stop and restart

打开任务管理器,点击服务按钮并搜索MySql服务,现在您可以停止并重新启动

enter image description here

在此处输入图片说明

enter image description here

在此处输入图片说明

回答by Lucky

In Windows,

在 Windows 中,

  • Open RunWindow by Win+R
  • Type services.msc
  • Search MySQLservice (Sometimes found as MySQL56or MySQL57) based on version installed.
  • Click stop, start or restart the service option.
  • Run通过Win+打开窗口R
  • 类型 services.msc
  • 基于安装的版本搜索MySQL服务(有时发现为MySQL56MySQL57)。
  • 单击停止、启动或重新启动服务选项。

回答by Jeff Northrup

These suggestions so far only work if the mysql server is installed as a windows service.

到目前为止,这些建议仅适用于将 mysql 服务器安装为 Windows 服务的情况。

If it is not installed as a service, you can start the server by using the Windows Start button ==> Run, then browse to the /bin folder under your mysql installation path and execute mysqld. Or just open a command window in the bin folder and type: mysqld

如果没有安装为服务,可以使用Windows开始按钮==>运行启动服务器,然后浏览到mysql安装路径下的/bin文件夹并执行mysqld。或者只是在 bin 文件夹中打开一个命令窗口并键入:mysqld

回答by Amac

First try:

第一次尝试:

net stop MySQL   
net start MySQL

If that does not work, try using the windows interface:

如果这不起作用,请尝试使用 Windows 界面:

Start > Control Panel > System and Security > Administrative Tools > Services

开始 > 控制面板 > 系统和安全 > 管理工具 > 服务

Look for your version of MySQL (In my case - MySQL55), highlight and click the green start arrow. The status should change to "Started"

查找您的 MySQL 版本(在我的情况下 - MySQL55),突出显示并单击绿色的开始箭头。状态应更改为“已开始”

回答by Oussama L.

use net stop mysql57 instead, it should be the version that is not specified

使用 net stop mysql57 代替,它应该是未指定的版本

回答by Aldo Escobar

I just have the same problem, just open the task manager, go to services tab and search MySQL_One service, rigth click and start, this works for very good.

我只是遇到了同样的问题,打开任务管理器,进入服务选项卡,搜索 MySQL_One 服务,右键单击并启动,这很好用。

回答by NightWind

Ctrl + alt +delete to start TASK MANAGER ,choose Service ,Then you will find MySQL, click that item by right click,then choose start, your MySQL Server will start!

Ctrl + alt +delete 启动 TASK MANAGER ,选择 Service ,然后你会找到 MySQL,右键单击该项目,然后选择 start,你的 MySQL Server 将启动!

回答by d3vnico

In order to prevent 'Access Denied' error:

为了防止“ Access Denied”错误:

Start->search 'Services' ->right click->Run as admistrator

Start->搜索 ' Services' -> right click->运行方式admistrator