MySQL Bugs: #3237: Windows MySQL service path entry corrupted

Bug #3237	Windows MySQL service path entry corrupted
Submitted:	18 Mar 2004 17:39	Modified:	27 Apr 2004 5:32
Reporter:	Jose Fandos	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.2B	OS:	Windows (Windows XP Pro SP1)
Assigned to:	Ulrich Bayer	CPU Architecture:	Any

Description:

After having changed the setting as reported in bug #3193 and not thinking more of it, I returned to my computer to find that there MySQL service is not starting. Upon inspection I find that the service path has changed to:

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

Since I did nothing else at all with MySQL administrator, the change mentioned in bug #3193 should be the cause.

How to repeat:
Modify the entry mentioned in bug #3193, restart the computer and MySQL service doesn't start anymore, giving Error#2: The system can't find the file specified. Trying to bring up MySQL Administrator gives error 2003: Can't connect to MySQL server on 'localhost'(10061)

Suggested fix:
Shouldn't MySQL Administrator run even when this happens? That would allow to fix errors like this one (in case MySQL Administrator wouldn't bork the entry but rather you had manually screwed it in a previous use). Having said that, it wouldn't allow you to screw it in the first place if it was working fine. Forget the suggestion :)

Just changing the synopsis from "Administrator fails to run giving error 2003" to one that points to the problem...

I've just tried to reproduce this myself. After using the browse button to change the Path to binary setting the path for the MySql service changes from:
C:\Program Files\MySQL\bin\mysqld-nt --defaults-file="C:\WINDOWS\my.ini" MySql
to
"C:\Program Files\MySQL\bin\mysqld-nt" --defaults-file="C:\WINDOWS\my.ini" MySql

It adds the (""). So I must have done something else, though I'm sure I didn't.

Hi,

You can start the MysqlAdministrator without connecting to a database. Hold Ctrl in the connection-dialog and click on "Skip".
Isn't that obvious? :-)