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:
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.5 plus OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[21 Jun 2013 23:24] Ed Reeder
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.
[22 Jun 2013 19:41] MySQL Verification Team
Local Service Code

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

[22 Jun 2013 19:44] MySQL Verification Team
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.
[23 Jun 2013 5:32] Ed Reeder
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
[24 Jun 2013 12:01] MySQL Verification Team
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.
[24 Jun 2013 22:09] Ed Reeder
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):

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.

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.