Bug #8030 mysqld_multi doesn't support --defaults-file
Submitted: 20 Jan 2005 6:09 Modified: 13 Jan 2011 10:40
Reporter: Michael Barton Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:mysql Ver 14.7 Distrib 4.1.9, for pc-li OS:Linux (Fedora Core 2)
Assigned to: CPU Architecture:Any
Triage: D5 (Feature request)

[20 Jan 2005 6:09] Michael Barton
To use mysqld_multi, I apparently have to define a username and password with shutdown privileges in /etc/my.cnf, which is world readable.

How to repeat:
not applicable?

Suggested fix:
If mysqld_multi supported the --defaults-file option similar to other command-line tools, I could create a cnf file that's not world readable and contains the [mysqld_multi] group, and then just access that from my startup script.

It's fairly simple, of course, just hook that option into the call to my_print_defaults.  Plus there's a typo in there I had to fix.

> $opt_defaults_file = undef();
<    die "Option file '$1' doesn't exists, or is not readable\n";
>    die "Option file '$1' doesn't exist, or is not readable\n";
>       if ($arg =~ m/^--defaults-file=(.*)/)
>       {
>         if (!length($1))
>         {
>           die "Option defaults-file requires an argument\n";
>         }
>         elsif (!( -e $1 && -r $1))
>         {
>           die "Option file '$1' doesn't exist, or is not readable\n"
>         }
>         else
>         {
>           $opt_defaults_file= $1;
>         }
>       }
>     $com.= "--defaults-file=$opt_defaults_file " if (defined($opt_defaults_file));
<              "silent","verbose")
>              "silent","verbose", "defaults-file=s")
[13 Dec 2010 10:40] Valeriy Kravchuk
This option is supported in current 5.0+ at least, as far as I can see. Please, check.
[14 Jan 2011 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".