MySQL Bugs: #70678: MySQL installer hangs on installation (community and enterprise editions)

Bug #70678	MySQL installer hangs on installation (community and enterprise editions)
Submitted:	21 Oct 2013 20:06	Modified:	19 Jun 2014 23:22
Reporter:	David Smith	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	mysql-server-5.6-winx64	OS:	Windows (2008 R2 Foundation Edition)
Assigned to:		CPU Architecture:	Any
Tags:	installation hangs, msi installer, windows server 2008 R2, x64, x86

Description:
mysql-server-5.6-winx64:6 - Looking for valid template
mysql-server-5.6-winx64:12 - Found valid template.
mysql-server-5.6-winx64:18 - Attempting to process template.
mysql-server-5.6-winx64:25 - Processed template.
mysql-server-5.6-winx64:31 - Attempting to configure service.
mysql-server-5.6-winx64:37 - Configured service.
mysql-server-5.6-winx64:43 - Attempting to start service.

How to repeat:
Install any version of MySQL for windows x86, x64 enterprise or community and the installation hangs on attempting to start service. Tried uninstalling, rebooting, reinstalling to no avail. Incidentally, MySQL works on the said machine when installed as part XAMPP package bundle. 

Suggested fix:
You tell me

edited synopsis

Thank you for the bug report. The failed installation was a fresh install or an upgrade ?. Thanks.

This is a fresh install.

The installation process never completes and I have tried multiple times. The cmmunity edition is the package I require. I have unistalled MySQL, rebooted, reinstalled but the issue is persistent.

Thank you for the feedback. Are you able to provide step by step sequence in your install process ?. Thanks.

I made sure that there were no installation files leftover on the system and deleted the service MySQL56 using cmd sc delete MySQL56. I then installed the http://dev.mysql.com/downloads/installer/5.7.html. Which is now working fine. Thanks

Please print here the output of the below command (change the mysql56 service
name for your one).

c:\dbs>sc qc mysql56
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: mysql56
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL56
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService

I met the same problem, any one can help? thanks! 

operation system:win8.1

install procedure: change nothing,just use default sets

I typed "c:\dbs>sc qc mysql56" and saw the following information

"[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: mysql56
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL56
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService"

I'm having the same issue.

   "[22 Oct 19:05] David Smith
I made sure that there were no installation files leftover on the system and deleted the service MySQL56 using cmd sc delete MySQL56. I then installed the http://dev.mysql.com/downloads/installer/5.7.html. Which is now working fine."

Followed this exactly and it didn't help. same hang up on starting service as with the MySQL56 installation.

Operating System: Windows 8.1

When I check the service, this is what I get:

C:\Windows\system32>sc qc mysql57
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: mysql57
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:/Program Files/MySQL/MySQL Server 5.7/bin\mysqld
" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL57
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService

Does anyone have a for sure fix??

Hi Godofredo miguel Solorzano,

   I tried it according to your prompt:

   "[18 Nov 20:43] Godofredo Miguel Solorzano
   Please open a command prompt screen with Administrator privileges and go
   to
   "C:\Program Files\MySQL\MySQL Server 5.6\bin" directory.
   Be sure the service MySQL56 is not running with the below command:
   sc query MySQL56
   Then issue the below command:
   mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini"
   --standalone --console"

   what the server prints is:
   "The file name, directory name, or volume label syntax is incorrect"

screen pic

Attachment: screen pic.png (image/png, text), 21.59 KiB.

thanx for your help!

ps：the my.ini can be found and opened（double click） in the right directory

Hello,  I have the same issue, any fix for this other than try the development version?

I have fixed, following this thread: http://bugs.mysql.com/bug.php?id=71071
Seems like the problem was the PATH that I choose to put the error and slow logs.

Regards.

Thank you for the feedback. So the issue was the wrong path in the service image path created by the installer (language issue?). Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

1: The action 'Install' for product 'MySQL Notifier 1.1.7' failed.
2: The action 'Install' for product 'MySQL for Visual Studio 1.2.6' failed.
3: The action 'Install' for product 'Connector/ODBC 5.3.7' failed.
4: The action 'Install' for product 'Connector/C++ 1.1.8' failed.
5: The action 'Install' for product 'Connector/J 5.1.40' failed.
6: The action 'Install' for product 'Connector/NET 6.9.9' failed.
7: The action 'Install' for product 'MySQL Connector/C 6.1.9' failed.
8: The action 'Install' for product 'MySQL Documentation 5.7.17' failed.
9: The action 'Install' for product 'Samples and Examples 5.7.17' failed.

The MySQL developers insist that running the MySQL service Logged On as NETWORK SERVICE IS the proper way to do it, and that running it as LOCAL SYSTEM opens security holes. I believe the root of the problem here is that NETWORK SERVICE can't access the locations where the log files are configured to be during setup. In my case, I specified the log files with the same names but browsed to a subfolder of my Documents folder which I created called MySQL Logs. So, (and this can be done while the installer dialog is open, it saying the installer is taking a long time, and prompting you to Wait or Cancel,):

I simply granted full control of that folder to the NETWORK SERVICE by right-clicking on the folder, selecting Properties, selecting Security, then clicking Add, then typing in "NETWORK SERVICE". Then I selected NETWORK SERVICE and clicked the checkboxes Allow for Full control and Modify.  I suspect if the directories for the log files aren't specified, this error isn't generated.