Most MySQL programs that support option files handle the following options. They affect option-file handling, so they must be given on the command line and not in an option file. To work properly, each of these options must be given before other options, with these exceptions:
--print-defaults may be used
immediately after
--defaults-file or
--defaults-extra-file.
On Windows, if the server is started with the
--defaults-file and
--install options,
--install must be first. See
Section 2.10.4.7, “Starting MySQL as a Windows Service”.
When specifying file names, you should avoid the use of the
“~” shell metacharacter because
it might not be interpreted as you expect.
--defaults-extra-file=
file_name
Read this option file after the global option file but (on
Unix) before the user option file. As of MySQL 5.0.6, if the
file does not exist or is otherwise inaccessible, the
program exits with an error.
file_name is the full path name
to the file.
Use only the given option file. If the file does not exist
or is otherwise inaccessible, the program exits with an
error. file_name is the full path
name to the file.
If this option is given, the program reads not only its
usual option groups, but also groups with the usual names
and a suffix of str. For example,
the mysql client normally reads the
[client] and [mysql]
groups. If the
--defaults-group-suffix=_other
option is given, mysql also reads the
[client_other] and
[mysql_other] groups. This option was
added in MySQL 5.0.10.
Do not read any option files. If a program does not start
because it is reading unknown options from an option file,
--no-defaults can be used to
prevent the program from reading them.
Print the program name and all options that it gets from option files.