restart mysql server on windows 7

MysqlWindows

Mysql Problem Overview

How do I restart MySQL on Windows 7?

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

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

Mysql Solutions

Solution 1 - Mysql

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

net stop MySQL57   
net start MySQL57

Solution 2 - Mysql

You can restart the service through the UI by following these steps:

  1. Open task manager (may need to run as administrator)

  2. Click on the "Service" button and find the "MySql" service

    NOTE: In some cases, the "MySql" service will be named whatever you named the initial database when you created the server. For example, if you called the initial database "myfirstdb", then the service would be called "myfirstdb". You should be able to find the service by sorting by the "Description" column as the description will be blank.

  3. Right-click on the "MySql" service and choose the "Restart" option

Thanks to @Doug_Ivison and @Lucky for the service name notes and "run as administrator" clarification in the comments.

enter image description here

enter image description here

Solution 3 - Mysql

In Windows,

  • Open Run Window by Win+R
  • Type services.msc
  • Search MySQL service (Sometimes found as MySQL56 or MySQL57) based on version installed.
  • Click stop, start or restart the service option.

Solution 4 - Mysql

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

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

Solution 5 - Mysql

First try:

net stop MySQL   
net start MySQL

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

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"

Solution 6 - Mysql

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

Solution 7 - Mysql

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.

Solution 8 - Mysql

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!

Solution 9 - Mysql

In order to prevent 'Access Denied' error:

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

Categories
Recommended Mysql Solutions
Recommended Windows Solutions

Previous Solution:

Resharper: Implicitly captured closure: this

C#.NetResharper

Next Solution:

file uploader integration for angularjs

File UploadAngularjs

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionNormanView Question on Stackoverflow
Solution 1 - MysqlORIONView Answer on Stackoverflow
Solution 2 - MysqlFrizz1977View Answer on Stackoverflow
Solution 3 - MysqlLuckyView Answer on Stackoverflow
Solution 4 - MysqlJeff NorthrupView Answer on Stackoverflow
Solution 5 - MysqlAmacView Answer on Stackoverflow
Solution 6 - MysqlOussama L.View Answer on Stackoverflow
Solution 7 - MysqlAldo EscobarView Answer on Stackoverflow
Solution 8 - MysqlNightWindView Answer on Stackoverflow
Solution 9 - Mysqld3vnicoView Answer on Stackoverflow