MySQL Bugs: #69547: Documentation describes a parameter for mysqld that does not exist

Bug #69547	Documentation describes a parameter for mysqld that does not exist
Submitted:	21 Jun 2013 23:24	Modified:	24 Jun 2013 22:09
Reporter:	Ed Reeder	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S2 (Serious)
Version:	5.5 plus	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
The --local-service parameter, as described in the documentation, does not exist for the mysqld executable.  See my "tip" for further details (http://dev.mysql.com/doc/mysql-windows-excerpt/5.0/en/windows-start-service.html)

How to repeat:
Try install mySQL as a "--local-service"

Suggested fix:
See my "tip" to find out what mysqld actually does and use what is appropriate in the documentation.

Local Service Code

Attachment: local_service.png (image/png, text), 30.70 KiB.

Thank you for the bug report, That option exists (see prior attached picture showing it in the debugger) what doesn't exist is the display of that option in the --help -verbose command,

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\mysql-5.5\sql\Debug>mysqld --install MySQL --defaults-file=c:\build\5.56\my.ini --local-service
Service successfully installed.

Thanks for the quick reply.  All I can say is that with Windows 7, the --local-service as described did NOT work. I tried a "<full path>\mysql\bin\mysqld --install MySQL --local-service" and it did not install the MySQL service.  Instead it installed a service called "--local-service".

So, if you say it should work, there are two problems:
1) the "--install-local" service does not perform as expected for, at least, Windows
2) the --verbose --help does not list the --local-service option

Thank you for the feedback. It works you can check it using the Control Panel->Administrative Tools->View Local Services->Service_Name->Properties->Log On.

As I said previously, I did a "<full path>\mysql\bin\mysqld --install MySQL --local-service"

This, according to the documentation, is valid syntax (there is no requirement to specify the --defaults-file option):

[FROM DOC]
You can also specify a --local-service option following the service name. This causes the server to run using the LocalService Windows account that has limited system privileges. This account is available only for Windows XP or newer. If both --defaults-file and --local-service are given following the service name, they can be in any order.
[/FROM DOC]

My use of the command did NOT install the MySQL service.  Instead it installed a service called "--local-service".

Your example from June 22 is different, as it has the --defaults-file specified.

Try the command as I did and see what happens.