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:
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

[16 Mar 2004 19:17] Jose Fandos
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.
[18 Mar 2004 17:26] Jose Fandos
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.
[18 Mar 2004 17:41] MySQL Verification Team
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
[12 Apr 2004 3:41] Michael G. Zinner
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