Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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.3.5.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. If the
file does not exist or is otherwise inaccessible, the program exits with an error. file_name is interpreted relative to the current
directory if given as a relative path name rather than a full path name.
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 interpreted relative to
the current directory if given as a relative path name rather than a full path name.
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.
Read options from the named login path in the .mylogin.cnf login file.
A "login path" is an option group
that permits only a limited set of options: host, user,
and password. Think of a login path as a set of values that indicate the
server host and the credentials for authenticating with the server. To create the login file, use
the mysql_config_editor utility. See Section
4.6.6, "mysql_config_editor — MySQL Configuration
Utility". This option was added in MySQL 5.6.6.
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.
The exception is that the .mylogin.cnf file, if it exists, is read in
all cases. This permits passwords to be specified in a safer way than on the command line even when
--no-defaults is used. (.mylogin.cnf
is created by the mysql_config_editor utility. See Section
4.6.6, "mysql_config_editor — MySQL Configuration
Utility".)
Print the program name and all options that it gets from option files.