MY\_PRINT\_DEFAULTS(1) MySQL Database System MY\_PRINT\_DEFAULTS(1)

# [NAME](#NAME)

my\_print\_defaults - display options from option files

# [SYNOPSIS](#SYNOPSIS)

**my\_print\_defaults \[options] option\_group ...**

# [DESCRIPTION](#DESCRIPTION)

**my\_print\_defaults** displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the **mysqlcheck** program reads the \[mysqlcheck] and \[client] option groups. To see what options are present in those groups in the standard option files, invoke **my\_print\_defaults** like this:

```
$> my_print_defaults mysqlcheck client
--user=myusername
--password=password
--host=localhost
```

The output consists of options, one per line, in the form that they would be specified on the command line.

**my\_print\_defaults** supports the following options.

•**--help**, **-?** Display a help message and exit.

•**--config-file=file\_name**, **--defaults-file=file\_name**, **-c file\_name** Read only the given option file.

•**--debug=debug\_options**, **-# debug\_options** Write a debugging log. A typical *debug\_options* string is d:t:o,*file\_name*. The default is d:t:o,/tmp/my\_print\_defaults.trace.

•**--defaults-extra-file=file\_name**, **--extra-file=file\_name**, **-e file\_name** Read this option file after the global option file but (on Unix) before the user option file.

For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

•**--defaults-group-suffix=suffix**, **-g suffix** In addition to the groups named on the command line, read groups that have the given suffix.

For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

•**--login-path=name**, **-l name** Read options from the named login path in the .mylogin.cnf login path file. A “login path” is an option group containing options that specify which MySQL server to connect to and which account to authenticate as. To create or modify a login path file, use the **mysql\_config\_editor** utility. See [mysql\_config\_editor(1)](/man/enterprise-packages/mysql-8.4/mysql_config_editor.1).

For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

•**--no-login-paths** Skips reading options from the login path file.

See **--login-path** for related information.

For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

•**--no-defaults**, **-n** Return an empty string.

For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.

•**--show**, **-s** **my\_print\_defaults** masks passwords by default. Use this option to display passwords as cleartext.

•**--verbose**, **-v** Verbose mode. Print more information about what the program does.

•**--version**, **-V** Display version information and exit.

# [COPYRIGHT](#COPYRIGHT)

Copyright © 1997, 2026, Oracle and/or its affiliates.

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

# [SEE ALSO](#SEE_ALSO)

For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/.

# [AUTHOR](#AUTHOR)

Oracle Corporation (http://dev.mysql.com/).

09/15/2026 MySQL 8.4

---

Document: my_print_defaults(1) from mysql-8.4 8.4.13-r0 (Chainguard OS)
Source: https://github.com/mysql/mysql-server