MySQL Bugs: #3193: Path to binary issues with spaces in path

Bug #3193	Path to binary issues with spaces in path
Submitted:	16 Mar 2004 19:17	Modified:	12 Apr 2004 3:41
Reporter:	Jose Fandos	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.2B ALPHA	OS:	Windows (Windows XP Pro SP1)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
On first install, going to "Service Control" -> "Configure Service" tab, the field "Path to binary:" has "C:\Program" as its value and it's in red. The setting should have been "C:\Program Files\MySQL\bin\mysqld-nt.exe".

The browse button following the "Path to binary:" text field allows me to choose the executable. Once that's done I do get "C:\Program Files\MySQL\bin\mysqld-nt", set in black. I would still expect .exe extension following the binary name, like "C:\Program Files\MySQL\bin\mysqld-nt.exe".

There is a setting in Windows Explorer under "Tools" -> "Folder Options..." -> "View" tab -> "Hide extensions for known file types" that does away with the .exe extensions (among others) when viewing files under Windows Explorer or the explorer-like browse windows like the one following the "Path to binary:" text field. I didn't have that particular setting checked, so I can see the extensions, including .exe. That was the case, too while browsing for the path. In my opinion it should show the full name of the binary, including the extension, all the time. Failing that, it should follow the setting I just mentioned.

A note: While browsing for the path I stopped short of clicking the binary and was clicking on the "Open" button of the browse window while having the folder selected. Might just be my (mis)understanding, but shouldn't that entry be better titled "MySQL Binary:" or "MySQL Executable:" or something similar rather than "Path to binary:"? The comment is also misleading as it reads "Directory containing the server".

I appreciate the care taken in the GUI to offer tooltips in buttons or comments following the fields. I would like to suggest following those comments, where necessary (isn't it always?), with a sample. So "Directory containing the server" could have been "MySQL path/binary (e.g. C:\MySQL\bin\mysqld-nt.exe)". The sample always helps when the text is not all that clear, and even when it's clear, I would say.

How to repeat:
Run MySQL Administrator on MySQL installation under folder with spaces in it.

I just realized that after having entered the information mentioned in the previous comment, my mysql service is not starting anymore, nor is MySQL Administrator, because the path in the service is now set to:

C:\/Program Files/MySQL/bin/ --defaults-file="C:\WINDOWS\my.ini" MySql

Filling another bug for it.

If you have the below service image path:

C:\/Program Files/MySQL/bin/ --defaults-file="C:\WINDOWS\my.ini" MySql

and it was made by MySQL Administrator..then it is a bug. Using the
server the service image path should look like below:

"D:\Arquivos de programas\4.0.17\bin\mysqld-nt" --defaults-file=c:\windows\my.ini MySQL

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