Bug #78838 MSI community installer hangs on service start
Submitted: 15 Oct 2015 1:23 Modified: 16 Oct 2015 13:49
Reporter: Matthew O' Hanlon Email Updates:
Status: Duplicate Impact on me:
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:5.6.27 OS:Windows (7 Ultimate)
Assigned to: CPU Architecture:Any
Tags: installer, services

[15 Oct 2015 1:23] Matthew O' Hanlon
I used the community installer to install mysql server among other available apps in the catalog. I accepted the defaults during installation with the exception of creating a different root password instead of leaving it blank. I try to get to the final stage where I apply the settings and it hangs trying to start the service. The rest of the apps are installed and I can open them, the problem is that I cannot start the service (because it is configured to run as a network service account, more on that later) and furthermore I cannot start the server because of the previous problem. 

I happened upon a workaround in Stackoverflow where the reporter said others had successfully started the MYSQL56 service when it is configured to run with the local system account. This is true also in my case, even though it wasn't for the person who reported the problem on SO. 

Link to SO question - http://stackoverflow.com/questions/20166952/unable-to-start-mysql-server

So on to my question. Is there another workaround or an actual solution for this problem? I would prefer not to run the service with the local system account because it has quite a lot of privileges. I'm using MYSQL Server for personal website development, so this isn't really that critical for me. I figured I should ask because it might be critical for someone else.

I would also like to get through a clean install using the installer. As it stands, I need to cancel the configuration of the installer. So to change the root password I need to use the utilities. Again, this isn't a huge setback, but it does require taking some time out to look through the docs to find out how to do this.

How to repeat:
I took some screenshots, I would like to attach them.

Suggested fix:
None that I know.
[15 Oct 2015 1:23] Matthew O' Hanlon
log from installer

Attachment: fail.png (image/png, text), 498.01 KiB.

[15 Oct 2015 1:24] Matthew O' Hanlon
shows user config for service

Attachment: network_service.png (image/png, text), 154.71 KiB.

[15 Oct 2015 1:27] Matthew O' Hanlon
shows service won't start

Attachment: network_service_fail.png (image/png, text), 178.65 KiB.

[15 Oct 2015 1:27] Matthew O' Hanlon
service set to run as local system account

Attachment: local_system.png (image/png, text), 155.61 KiB.

[15 Oct 2015 1:27] Matthew O' Hanlon
service starts when run as local system

Attachment: local_system_success.png (image/png, text), 169.31 KiB.

[15 Oct 2015 6:27] Chiranjeevi Battula
Hello Matthew,

Thank you for the bug report.
This is most likely duplicate of Bug #77674 & Bug #76476, please see Bug #77674 & Bug #76476

[16 Oct 2015 13:49] Matthew O' Hanlon
Hi Chiranjeevi,

Thanks for taking the time to look into my report. I have looked at both the bugs you linked. The first one (#77674) doesn't seem to be related to my problem. I can still see the service in my list of services. The second is definitely related to my problem. The workarounds listed in the comments of the bug though didn't really work for me. Specifically, I tried turning off ALL of my firewall rules (which are managed by 3rd party vendor software - Avast), but it didn't seem to have an effect at all. There was another workaround suggested, but I wasn't able to follow through on it. It was suggested that you delete the 32-bit mysql server from the installer, but I wasn't able to do that successfully. Maybe I could try a zip file? Is there a way to direct the installer to look in a different directory to install just the 64-bit version instead of both?

Thanks again for your help!