MySQL Bugs: #69637: mysqld --local-service parameter does not work

Bug #69637	mysqld --local-service parameter does not work
Submitted:	1 Jul 2013 17:30	Modified:	15 Nov 2013 17:04
Reporter:	Ed Reeder	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.5 plus	OS:	Windows (Windows 7/64)
Assigned to:		CPU Architecture:	Any
Tags:	local-service, mysqld

Description:
You can find more about this bug here http://bugs.mysql.com/bug.php?id=69547

I initially reported it as a documentation bug but they kicked it here.

The bottom line is that 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

The following command:
"<full path>\mysql\bin\mysqld --install MySQL --local-service"

installs a service named "--local-service", NOT MySQL service.

How to repeat:
Under Windows 7.  Follow your documentation http://dev.mysql.com/doc/mysql-windows-excerpt/5.0/en/windows-start-service.html

and issue the command
"<full path>\mysql\bin\mysqld --install MySQL --local-service"

Look at the Windows services and you'll see service named "--local-service"

Command crash Server

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

Thank you for the bug report. Indeed without --defaults-file... I got the server crash (see prior picture attached).

Noted in 5.5.36, 5.6.15, 5.7.4 changelogs.

On Windows, the --local-service server option did not work, and was
not displayed in the --help message.

5.5$ bzr log -r 4547
------------------------------------------------------------
revno: 4547
committer: Atanu Ghosh <atanu.ghosh@oracle.com>
branch nick: mysql-5.5
timestamp: Thu 2013-11-14 14:27:31 +0530
message:
  Bug #17049656 : MYSQLD --LOCAL-SERVICE PARAMETER DOES NOT WORK
  
  Problem: The "--local-install" service does not perform as expected for, at least,
           Windows.
  
  Fix: A NULL pointer was dereferenced due to which there was crash.A check was introduced
       for NULL string before dereferencing it.No test cases written as it is a bug during 
       installation.