MySQL Bugs: #27920: Using passive install or skipping configuration causes bad service install

Bug #27920	Using passive install or skipping configuration causes bad service install
Submitted:	18 Apr 2007 9:30	Modified:	18 Apr 2007 10:58
Reporter:	Lionel van den Berg	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.0.17,5.0.24,5.0.27,5.0.37	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
After installing MySQL passively, i.e., with minimal user interface, and then installing MySQL as a windows service using mysqld-nt --install, the service will not start correctly. Specifically:

> mysqld-nt install
Service successfully installed.

> net start mysql
The MySQL service is starting

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

>

If I try to start it with mysqld-nt and no arguments it fails. I can successfully start it with any of the following:
mysqld-nt --verbose
mysqld-nt --console
mysqld-nt --basedir="F:\Program Files\MySQL\MySQL Server 5.0"

However, none of these options are really satisfactory. I need to install MySQL as a service and have it run automatically each time windows starts.

How to repeat:
Install mysql from a prompt as follows:

mysqlinstallername.msi /passive

Skip registration.

Or install mysql normally but don't configure when it asks.

Then:

install as windows service with
mysqld-nt install

and try

net start mysql

Suggested fix:
The service should install seemlessly following these steps. The wizard must be doing something behind the scenes!

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Read about installation options at http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html

Seems you forgot indicate location of your configuration file.

I don't understand why I have to provide a configurations file when everything is installed in the default directory. This means that I have to automatically generate a configurations file customised for the system even though MySQL should know all this already! MySQL does choose the installation directory.