Bug #57093 --install option to mysqld not working if not listed first

Submitted: 29 Sep 2010 10:04 Modified: 29 Sep 2010 10:08
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Installing Severity:S4 (Feature request)
Version:5.1, 5.5.6rc OS:Windows
Assigned to: CPU Architecture:Any

[29 Sep 2010 10:04] Roel Van de Paar
Description:
C:\mysql556rc\bin>mysqld --defaults-file=c:\mysql556rc\my.ini --install mysql556rc

C:\mysql556rc\bin>net start mysql556rc
The service name is invalid.

error log:
100929 19:53:27 [ERROR] mysqld: unknown option '--install'

C:\mysql556rc\bin>mysqld --install mysql556rc --defaults-file=c:\mysql556rc\my.ini
Service successfully installed.

C:\mysql556rc\bin>net start mysql556rc
The mysql556rc service is starting..
The mysql556rc service was started successfully.

How to repeat:
As per the above
[29 Sep 2010 10:08] Roel Van de Paar
Yet, contradictory, if --install is not used, --defaults-file needs to be the first option:

C:\mysql\bin>mysqld --server-id=5 --defaults-file=c:\mysql\my.ini
<terminates>

Error log:
100929 20:05:31 [ERROR] mysqld: unknown variable 'defaults-file=c:\mysql\my.ini'
100929 20:05:31 [ERROR] Aborting

(Notice the missing dashes also)

Very confusing, especially when the manual says "To work properly, each of these options [including --defaults-file] must immediately follow the command name" - yet clearly --install needs to go before it and not behind.
[29 Sep 2010 10:11] Roel Van de Paar
(http://dev.mysql.com/doc/refman/5.1/en/option-files.html)
[29 Sep 2010 10:21] Roel Van de Paar
Looks like it's a documented:
http://dev.mysql.com/doc/refman/5.5/en/windows-start-service.html

In that case, please update manual at:
http://dev.mysql.com/doc/refman/5.1/en/option-files.html

To include this exception (--install)
[29 Sep 2010 10:22] Roel Van de Paar
After the docs have been updated, please assign back to me. I'd like to make a FR out of this to have the behavior changed to accept options in any location.
[29 Sep 2010 14:47] Paul DuBois
Documentation updated. Assigning back to Roel per Roel's request.
[30 Sep 2010 22:15] Roel Van de Paar
Feature request (preferably for 5.5): please change the behavior to accept (any) options in any location.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.