MY_PRINT_DEFAULTS(1)

💅 NAME 💅

my_print_defaults — bestie, this one literally displays options from option files. That's the whole gig. No cap.

This is the MY_PRINT_DEFAULTS(1) page, straight outta the MariaDB Database System manual. Let's get into it 🎀

---

✨ SYNOPSIS ✨

my_print_defaults [options] option_group ...

---

🦋 DESCRIPTION 🦋

Okay so here's the tea: my_print_defaults shows you the options that are chillin' inside option groups of option files. The output tells you what options are actually gonna get used by programs that read those option groups you named. It's giving detective work, honestly 🔍✨

Like, real example: the mariadb-check program reads the [mariadb-check] and [client] option groups. So if you wanna see what's in those groups in the standard option files, you invoke my_print_defaults like this:

shell> my_print_defaults mariadb-check client
--user=myusername
--password=secret
--host=localhost

The output is just options, one per line, in the exact form they'd be specified on the command line. Slay 💅

my_print_defaults supports these options, and yes bestie, we're going through every single one 🫶

---

👑 OPTIONS 👑

• --help, -? — shows you a help message and dips. That's it, that's the option 💖
• --defaults-file=file_name, -c file_name — read only the given option file. If no extension is given, the default extension (.ini or .cnf) will be used. And listen: if --defaults-file is the first option, then it reads this file only — no global config files, no per-user config files. It should be the first option. First. Position. Only. 👑
• --debug=debug_options, -# debug_options — writes 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'. Cute little trace file, living its best life in /tmp 🍓
• --defaults-extra-file=file_name, -e file_name — reads this option file after the global option file but (on Unix) before the user option file. Should be the first option. Yeah bestie, first again 😭
• --defaults-group-suffix=suffix, -g suffix — in addition to the groups you named on the command line, it also reads groups that have the given suffix. Extra credit energy ✨
• --mariadbd — reads the same set of groups that the mariadbd binary does.
• --mariadbd — reads the same set of groups that the mariadbd binary does.

Not me listing --mariadbd twice 💀 but fr fr, the page lists it twice, so here it is twice. Twinning. Iconic. No notes.

• --no-defaults, -n — returns an empty string (super useful for scripts). Nothing. Void. Silence. Very demure 🌸
• --verbose, -v — verbose mode. Prints more information about what the program does. Yapper mode: activated 🗣️
• --version, -V — displays version information and exits. Byeee 👋

---

🎀 COPYRIGHT 🎀

Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2025 MariaDB Foundation

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. (Yes bestie, that's the dramatic part. Read it again. There is genuinely no warranty 😭)

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-1335 USA or see http://www.gnu.org/licenses/.

---

🌈 SEE ALSO 🌈

For more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/

---

🧚 AUTHOR 🧚

MariaDB Foundation (http://www.mariadb.org/). Kings, honestly 👑

---

That's the whole page, bestie. Written for MariaDB 11.8, dated 5 March 2025, and filed under MY_PRINT_DEFAULTS(1). Go read your option files. Periodt 💖✨