OS Manuals

/usr/bin/my_print_defaults

The MariaDB open source relational database

From mariadb-10.6 10.6.12-r1 (os), captured 2026-11-05 by running my_print_defaults --help (exit 0). permalink

/usr/bin/my_print_defaults  Ver 1.7 for Linux at x86_64
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Displays the options from option groups of option files, which is useful to see which options a particular tool will use
Usage: /usr/bin/my_print_defaults [OPTIONS] [groups]
  -#, --debug[=#]     This is a non-debug version. Catch this and exit
  -c, --defaults-file=name
                      Read this file only, do not read global or per-user
                      config files; should be the first option
  -e, --defaults-extra-file=name
                      Read this file after the global config file and before
                      the config file in the users home directory; should be
                      the first option
  -g, --defaults-group-suffix=name
                      In addition to the given groups, read also groups with
                      this suffix
  --mysqld            Read the same set of groups that the mysqld binary does.
  -n, --no-defaults   Return an empty string (useful for scripts).
  -?, --help          Display this help message and exit.
  -v, --verbose       Increase the output level
  -V, --version       Output version information and exit.

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
defaults-file                     my
defaults-extra-file               (No default value)
defaults-group-suffix             (No default value)
mysqld                            FALSE

Example usage:
/usr/bin/my_print_defaults --defaults-file=example.cnf client client-server mysql
Options (9)
OptionDescriptionSource
-#, --debug #This is a non-debug version.help
-c, --defaults-file nameRead this file only, do not read global or per-user config files;help
-e, --defaults-extra-file nameRead this file after the global config file and before the config file in the users home directory;help
-g, --defaults-group-suffix nameIn addition to the given groups, read also groups with this suffixhelp
--mysqldRead the same set of groups that the mysqld binary does.help
-n, --no-defaultsReturn an empty string (useful for scripts).help
-?, --helpDisplay this help message and exit.help
-v, --verboseIncrease the output levelhelp
-V, --versionOutput version information and exit.help

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.