Bug #1412 mysqld service won't start if installed with --defaults-file option
Submitted: 26 Sep 2003 13:15 Modified: 10 Dec 2003 4:48
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.15 OS:Windows (Win NT, 2000)
Assigned to: MySQL Verification Team CPU Architecture:Any

[26 Sep 2003 13:15] Paul DuBois
Description:
The --defaults-file option seems to prevent a server installed as a service from starting.

Background: I have only the C:/my.cnf option file. I don't have a my.ini file in the Windows
directory.

If the server is installed with this command, it runs properly when started:

mysqld-nt --install

If the server is installed with this command, it does not run properly when started:

mysqld-nt --install mysql --defaults-file=C:/my.cnf

Because I have only the C:/my.cnf option file on my system, the two installation commands should 
be equivalent. (Note, however, that use of --defaults-file with any option file causes startup 
failure.)

I see the same failure on Windows NT and 2000 when a 4.0.15 server is installed with the --
defaults-file option.

The startup error varies per version of Windows. On Windows 2000, the Services control panel 
reports that the service failed to respond in a timely manner to the control function. On Windows 
NT, I see: Error 2186: The service is not responding to the control function.

I have also tried these installation commands with MySQL 4.0.13 and 4.0.19 on Windows 2000. 
The server starts up properly either way, whether installed with or without --defaults-file.

I have also tried 4.0.13 on Windows NT, and the server starts up properly either way.

The problem appears to be specific to 4.0.15 (or perhaps 4.0.14, which I have not tried).

My investigation of this problem began as a result of a thread on win32@. The subject heading is: 
installing MySQL4.0.15 as a service on windows 2000

How to repeat:
Use description above.
[26 Sep 2003 22:40] MySQL Verification Team
Thank you for your bug report i was able to repeat.
[16 Oct 2003 21:30] MySQL Verification Team
Thank you for the bug report a patch was submitted for approval.
[20 Nov 2003 15:55] David Patterson
I have the same problem under Ver 4.0.16
[10 Dec 2003 4:48] Michael Widenius
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

The fix will be in 4.0.17 and 4.1.1