Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to start MySQL server

Tags:

mysql

windows

Running Windows 7 64-bit.

I've been unable to start an instance of MySQL 5.6 server. When I attempt to start it from within the MySQL workbench, I get this:

2013-11-23 14:05:07 - Checking service status of instance MySQL...
2013-11-23 14:05:07 - Status check of service 'MySQL' returned stopped

I've tried manually starting the Windows service. Following advice that worked for others with the same problem, I've configured the service to log on as "Local System account". No dice; it throws this:

error 1053: the service did not respond to the start or control request in a timely fashion

I've also tried disabling my firewall, and completely reinstalling MySQL server.

It should perhaps be noted that (I assume as a result of all this) I also cannot log into the MySQL command line client. It tells me:

Can't connect to MySQL server on 'localhost' (10061)

This is my first time trying to set up a MySQL server, so perhaps there's just something I've missed. If so, I'm unsure what it is.

like image 418
The_Unobsequious Avatar asked Nov 23 '13 19:11

The_Unobsequious


People also ask

Can't start MySQL server workbench?

This issue usually results from an incorrect service name reference. This arises when the MySQL Workbench contains a reference to an older service name (e.g. mysql), whereas MySQL Server 8.0. x uses the service name MySQL80.

Can't start MySQL service while installing?

Restart the machine and try Instance Configuration Again. Uninstall all MySQL software and making sure that there was no service and reinstall.


1 Answers

I had the same issue. Try this, it should work!

  1. Right click on MySQL Notifier -> Actions -> Manage Monitored Items

  2. Highlight the MySQL56 entry and click the delete button

  3. Click the add button -> windows service
  4. Scroll down and look for MySQL56
  5. Highlight it and click ok
like image 151
Besan Vadim Avatar answered Sep 22 '22 11:09

Besan Vadim