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:Microsoft Windows
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[27 Nov 2010 15:00] Anders Karlsson
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.
[27 Nov 2010 19:38] Peter Laursen
@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!)
[27 Nov 2010 23:31] Anders Karlsson
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.
[29 Nov 2010 9:48] Valeriy Kravchuk
I do not see mysqld_multi.pl in 5.5.7. Please, check.
[29 Nov 2010 10:09] Anders Karlsson
It's in 32-bit only. As stated in the bug report.
[29 Nov 2010 13:16] Valeriy Kravchuk
I do not see it in 5.5.7 on 32-bit Windows XP. Had you checked this version?
[30 Nov 2010 6:21] Anders Karlsson
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.
[2 Dec 2010 2:54] Miguel Solorzano
Thank you for the bug report.