Bug #1988 Mysqld-nt does not like spaces in the Windows Service name.
Submitted: 1 Dec 2003 10:08 Modified: 4 Dec 2003 10:12
Reporter: Venkat Ganesh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:v4.0.14-nt OS:NT
Assigned to: MySQL Verification Team CPU Architecture:Any

[1 Dec 2003 10:08] Venkat Ganesh
Description:
There is a bug in mysqld-nt v4.0.14 if the Windows service name has a space in it. The service gets installed correctly but it will not start, as shown below. 

D:\mysql\SI\mysql\bin>mysqld-nt -version
mysqld-nt  Ver 4.0.14-nt for NT on i32

D:\mysql\SI\mysql\bin>mysqld-nt --install-manual "First Mysql Windows Service" -
-defaults-file=D:\mysql\SI\mysql\data\my.cnf
Service successfully installed.

D:\mysql\SI\mysql\bin>net start "First Mysql Windows Service"
The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

D:\mysql\SI\mysql\bin>

How to repeat:
mysqld-nt --install-manual "First Mysql Windows Service" -
-defaults-file=D:\mysql\SI\mysql\data\my.cnf

net start "First Mysql Windows Service"
The service is not responding to the control function.

More help is available by typing NET HELPMSG 2186.

Suggested fix:
Workaround. Edit registry and change ImagePath entry as shown below. 

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\First Mysql Windows Service\ImagePath to 

D:\SI\mysql\bin\mysqld-nt --defaults-file=D:\SI\mysql\data\my.cnf "First Mysql Windows Service"

The windows service name must be enclosed within double quotes. After this change I am able to start it.
[3 Dec 2003 14:28] MySQL Verification Team
Thank you for the debug report. I was able to repeat.
[3 Dec 2003 20:17] MySQL Verification Team
Since is common practice to use service custom name with space
on Windows I am assuming this report as a bug rather than
feature request.
[4 Dec 2003 10:12] MySQL Verification Team
Thank you for this bug report this issue was already fixed in
our BK 4.0 tree:

ChangeSet  1.1644 03/12/04 19:48:10 monty@mysql.com +7 -0