MySQL Bugs: #58533: mysqld_multi fails with my_print

Bug #58533	mysqld_multi fails with my_print_defaults not found
Submitted:	27 Nov 2010 15:00	Modified:	2 Dec 2010 2:54
Reporter:	Anders Karlsson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.5.7	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Running mysqld_multi.pl on Windows will not work, it looks for my_print_defaults and claims it cannot find it, despite being in the path. It may well be that mysqld_multi.pl was not intended to work on Windows, but if so, why is it distributed.

How to repeat:
Install MySQL 5.5.6 32-bit. To be able to run this command, I downloaded strawberry Perl for Windows. Running mysqld_multi produces:

C:\>perl C:\MySQL\bin\mysqld_multi.pl
WARNING: my_print_defaults command not found.
Please make sure you have this command available and
in your path. The command is available from the latest
MySQL distribution.
WARNING: Log file disabled. Maybe directory or file isn't writable?
ABORT: Can't find command 'my_print_defaults'.
This command is available from the latest MySQL
distribution. Please make sure you have the command
in your PATH.

my_print_defaults is actually available in the path here.

Suggested fix:
Make sure mysqld_multi work, or, if it's not suppoed to work on Windows, remove it from the distribution. It already seems gone from the 64-bit version.

@Anders ..

.. why use mysqld_multi on Windows?  Windows will not need neither this nor 'sandbox' to run multiple MySQL instances.  It does 'out of the box' as long as servicenames and ports do not conflict. 

(just my curiosity - and does not exclude a bug or inconsistency in the Windows packages of course!)

yes, musqld_multi seems useless on Windows. Which is why I was curious to find out why it was shipped at all. But it didn't even work, so why it is there in the distro bugs (!) me: It doesn't work and it seems to be useless, even if it DID work.

I do not see mysqld_multi.pl in 5.5.7. Please, check.

It's in 32-bit only. As stated in the bug report.

I do not see it in 5.5.7 on 32-bit Windows XP. Had you checked this version?

I just realized this is only the case for the package without the installer, not for the MSI. So look in mysql-5.5.7-rc-win32.zip. Sorry for the confusion.

Thank you for the bug report.