MySQL Bugs: #62434: Service not set up when adding MySQL Server after initial Client Only install

Bug #62434	Service not set up when adding MySQL Server after initial Client Only install
Submitted:	14 Sep 2011 16:17	Modified:	20 Jul 2015 23:57
Reporter:	Paul Keenan	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S3 (Non-critical)
Version:	5.5.15.0	OS:	Windows (XP SP3)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When installing initially using MySQL Installer, I opted for a "Client Only" install.  When using the MySQL Installer to add the MySQL Server later, the configuration process failed to install the MySQL55 service despite being checked.

How to repeat:
1. Install MySQL Installer, choosing "Client Only" install type.  Complete the installation and close.

2. Start -> Program Files -> MySQL -> MySQL Installer.

3. Choose "Add/Modify Products and Features".

4. From the MySQL Server options, click "MySQL Server 5.5.15" on the centre pane.  Deselect all but the first three components : MySQL Server, Client Programs, Debug binaries.  Complete the install

5. During configuration, select Developer Machine.  Accept defaults of "Enable TCP/IP Networking", "Create Windows Service".  Set a root password.  Complete the configuration.

6. Open the Services control panel.  There is no "MySQL55" service in the list.

I couldn't repeat assuming the same step sequence as bug: http://bugs.mysql.com/bug.php?id=62422.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\miguel>sc qc MySQL55
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: MySQL55
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.
5\my.ini" MySQL55
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL55
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem

C:\Users\miguel>

Hi Miguel,

Thanks for looking into this.  Can you check again ?  This is 100% repeatable from my end.  I'll be more detailed about the key step 4.  To reproduce the problem :

4a. Tick "MySQL Server 5.5.15" in centre pane.
   - all 8 boxes in right pane become ticked.

4b. Untick "Development Components"
   - "Client C API library (shared)" becomes unticked.
   - "Embedded server library" becomes unticked.

4c. Untick "Debug Symbols".

4d. Untick "Server data files".

You now should only have the top 3 boxes on the right ticked - "MySQL Server", "Client files" and "Debug binaries"

Now proceed with installation & configuration.  Despite asking for MySQL to be configured as a service, the onfiguration details is like this :
-------------------------------------------------------------
mysql-server-5.5-win32-gpl:6 - Looking for valid template
mysql-server-5.5-win32-gpl:13 - Found valid template.
mysql-server-5.5-win32-gpl:20 - Attempting to process template.
mysql-server-5.5-win32-gpl:100 - Product configuration controller finished configuration.
-------------------------------------------------------------

And the result :
-------------------------------------------------------------
~$ sc qc MySQL55
[SC] OpenService FAILED 1060:

The specified service does not exist as an installed service.
-------------------------------------------------------------

If you miss out step 4d, i.e. leave the "Server data files" box ticked, the service is installed.  The configuration details in this case :

-------------------------------------------------------------
mysql-server-5.5-win32-gpl:6 - Looking for valid template
mysql-server-5.5-win32-gpl:13 - Found valid template.
mysql-server-5.5-win32-gpl:20 - Attempting to process template.
mysql-server-5.5-win32-gpl:26 - Processed template.
mysql-server-5.5-win32-gpl:33 - Attempting to configure service.
mysql-server-5.5-win32-gpl:40 - Configured service.
mysql-server-5.5-win32-gpl:46 - Attempting to start service.
mysql-server-5.5-win32-gpl:53 - Started service.
mysql-server-5.5-win32-gpl:60 - Adding firewall rule for MySQL55 on port 3306.
mysql-server-5.5-win32-gpl:66 - Adding firewall rule was successful.
mysql-server-5.5-win32-gpl:73 - Attempting to update security settings.
mysql-server-5.5-win32-gpl:80 - Updated security settings.
mysql-server-5.5-win32-gpl:86 - Attempting to verify command-line client shortcut.
mysql-server-5.5-win32-gpl:93 - Verified command-line client shortcut.
mysql-server-5.5-win32-gpl:100 - Product configuration controller finished configuration.
-------------------------------------------------------------

The new result:

-------------------------------------------------------------
~$ sc qc MySQL55
[SC] GetServiceConfig SUCCESS

SERVICE_NAME: MySQL55
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="D:\Profiles\All Users\Application Data\My
SQL\MySQL Server 5.5\my.ini" MySQL55
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL55
        DEPENDENCIES       :
        SERVICE_START_NAME : LocalSystem
-------------------------------------------------------------

Let me know if you need any more details.

I can 100% reproduce this behaviour having installed MySQL Server in full, then uninstalling it.

Reinstalling it is now impossible - every single time it fails to start the service in the Configurator - responding with error 0.

Doing install Repair/Uninstall/Reinstall makes no difference - neither does restarting the OS, or manually deleting the mysql services and registry key for the service(I tried this /after/ encountering the problem). 

I am left with a useless XP server at this time - infuriating! it has cost me days worth of setup time.

OS : Windows XP 32b w/SP3 - fully up to date.
MySQL : v5.5.16-win32

The root cause of this problem is NO SERVER FILES are selected at the feature screen to be copied into the system, files required to run the service on the first place (Default location: Program Files folder). In this case, the server-configuration screens should be skipped.

Short steps to reproduce: 
- Select the "Server only" option.
- Select the "Custom" option and click next button.
- Observe MySQL Server product is selected with all of its features (in the next box), unselect the first three listed features by clicking on their boxes (MySQL Server, Client Programs, Debug binaries).
- Click next and proceed until the service fails to start.

Server configuration is only available for new Server installations. Upgrades
and Feature changes will not allow for server re-configuration. Because the
server was initially installed as Client Only, future attempts to change the
installed features will not allow for a configuration.