# my\_print\_defaults

`my_print_defaults` displays the options from option groups of option files. It is useful to see which options a particular tool will use.

Output is one option per line, displayed in the form in which they would be specified on the command line.

### Usage

```ini
my_print_defaults [OPTIONS] [groups]
```

### Options

| Option                             | Description                                                                                                                                                                                  |
| ---------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| -c, --config-file=*name*           | Deprecated, use `--defaults-file` instead. Name of config file to read; if no extension is given, default extension (`.ini` or `.cnf`) are added.                                            |
| -d, --debug\[=#]                   | In debug versions, 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`.                                         |
| -c, --defaults-file=*name*         | Like `--config-file`, except if it is the first option. In that case, read this file only, do not read global or per-user config files; should be the first option. Removed in MariaDB 10.8. |
| -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. Removed in MariaDB 10.8.                                     |
| -g, --defaults-group-suffix=*name* | In addition to the given groups, read also groups with this suffix. Removed in MariaDB 10.8.                                                                                                 |
| -e, --extra-file=*name*            | Deprecated. Synonym for `--defaults-extra-file`.                                                                                                                                             |
| --mariadbd                         | Read the same set of groups that the [mariadbd](https://mariadb.com/docs/server/server-management/starting-and-stopping-mariadb/mariadbd) server does. Available from MariaDB 10.11.3.       |
| --mysqld                           | Read the same set of groups that the [mysqld](https://mariadb.com/docs/server/clients-and-utilities/legacy-clients-and-utilities/mariadbd_safe) server 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.                                                                                                                                                         |

### Examples

```
my_print_defaults --defaults-file=example.cnf client client-server mysql
```

[mariadb-check](https://mariadb.com/docs/server/clients-and-utilities/table-tools/mariadb-check) reads from the `[mariadb-check]` and `[client]` sections in [option files](https://mariadb.com/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files), so the following would display the mariadb-check options.

```
my_print_defaults mariadb-check client
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}