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:
None 
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

[20 Jan 2005 6:09] Michael Barton
Description:
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.

21a22
> $opt_defaults_file = undef();
64c65
<    die "Option file '$1' doesn't exists, or is not readable\n";
---
>    die "Option file '$1' doesn't exist, or is not readable\n";
70a72,80
>       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;
>         }
>       }
73a84
>     $com.= "--defaults-file=$opt_defaults_file " if (defined($opt_defaults_file));
81c92
<              "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".

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.