Command-Line Options that Affect Option-File Handling
Most MariaDB 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 immediately follow the command name, with these exceptions:
--print-defaults
may be used immediately after--defaults-file
or--defaults-extra-file
.- On Windows, if the
--defaults-file
and--install
options are given,--install
option must be first. See , "Starting MariaDB 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.--defaults-file=
file_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.--defaults-group-suffix=
str
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.--no-defaults
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-defaults
Print the program name and all options that it gets from option files.