OS Manuals

/usr/bin/my_print_defaults

The MySQL open source relational database

From mysql-9.1 9.1.0-r5 (os), captured 2026-11-05 by running my_print_defaults --help (exit 0). permalink

/usr/bin/my_print_defaults  Ver 9.1.0 for Linux on x86_64 (Source distribution)
Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Prints all arguments that is give to some program using the default files
Usage: /usr/bin/my_print_defaults [OPTIONS] groups
  -c, --config-file=name
                      Deprecated, please use --defaults-file instead. Name of
                      config file to read; if no extension is given, default
                      extension (e.g., .ini or .cnf) will be added
  -#, --debug[=#]     This is a non-debug version. Catch this and exit
  -c, --defaults-file=name
                      Like --config-file, except: if first option, then 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
  -e, --extra-file=name
                      Deprecated. Synonym for --defaults-extra-file.
  -n, --no-defaults   Ignore reading of default option file(s), except for
                      login file.
  -l, --login-path=name
                      Path to be read from under the login file.
  -x, --no-login-paths
                      Ignore reading of the login file.
  -s, --show          Show passwords in plain text.
  -?, --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/mysql/my.cnf /etc/my.cnf ~/.my.cnf

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

Example usage:
/usr/bin/my_print_defaults --defaults-file=example.cnf client mysql
Options (11)
OptionDescriptionSource
-c, --config-file nameDeprecated, please use --defaults-file instead.help
-#, --debug #This is a non-debug version.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
-n, --no-defaultsIgnore reading of default option file(s), except for login file.help
-l, --login-path namePath to be read from under the login file.help
-x, --no-login-pathsIgnore reading of the login file.help
-s, --showShow passwords in plain text.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.