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

[18 Apr 2007 9:30] Lionel van den Berg
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!
[18 Apr 2007 9:42] Sveta Smirnova
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.
[18 Apr 2007 10:58] Lionel van den Berg
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.