Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Installer Stuck on "Starting Service"

I recently had a successful install of MySQL 5.6.21 using the MySQL installer on Windows Server 2012 R2. I needed to make some modifications and tried to re-install.

Now MySQL is hanging on "Starting Service".

enter image description here

I've tried the following:

  • Uninstall using Control Panel
  • Delete Service using "sc delete MySQL56"
  • Delete all MySQL files from "Program Files" & "c:\programdata"

Has anyone seen this problem? If so, how were you able to fix it?

like image 436
Jayson H Avatar asked Sep 25 '14 20:09

Jayson H


People also ask

Can't start MySQL service while installing?

First try restart PC and MySql Service couple of times ,if still getting same error then follow the steps. Keep open the following wizards and folders: C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin. C:\Program Files (x86)\MySQL\MySQL Server 5.5.

Why MySQL service is not starting?

Even with correct ownership, MySQL might fail to start up if there is other security software running on your system that manages application access to various parts of the file system. In this case, reconfigure that software to enable mysqld to access the directories it uses during normal operation.


2 Answers

I just had that very same problem on Windows 7 pro 64 bit with latest mysql-installer-web-community-5.6.23.0.msi installer and I resolved it this way

Installer stuck because user who is supposed to start service is set erroneously.

like image 176
Nenad Bulatović Avatar answered Sep 20 '22 03:09

Nenad Bulatović


TURN OFF WINDOWS FIREWALL COMPLETELY BEFORE INSTALLING


This was one of the only threads I could find on this issue and the current answers did not cut the mustard for me.

MySQL 5.6.21, both x86 and x64, did not want to get past "Starting Server" and would give me the "MySQL install taking longer than expected" message.

I tried all of the registry cleaner, folder deletions, etc to no avail.

I am running Windows 7 x64 and I finally decided to check the event viewer to find this:

enter image description here

0x80070422 turns out to be some unspecified firewall error and boom, it struck me like lightning.

I hope this post helps future visitors!

like image 30
MonkeyZeus Avatar answered Sep 24 '22 03:09

MonkeyZeus