my_print_defaults (1) Linux Manual Page
NAME
my_print_defaults – display options from option files
SYNOPSIS
-
my_print_defaults [options]option_group…
DESCRIPTION
my_print_defaults
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:
-
shell>
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,-cfile_nameRead only the given option file.
- •
–debug=debug_options,-#debug_optionsWrite 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,-efile_nameRead 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 4.2.2.3, “Command-Line Options that Affect Option-File Handling”.
- •
–defaults-group-suffix=suffix,-gsuffixIn 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 4.2.2.3, “Command-Line Options that Affect Option-File Handling”.
- •
–login-path=name,-lnameRead 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_editorutility. Seemysql_config_editor(1).For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”.
- •
–no-defaults,-nReturn an empty string.
For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”.
- •
–show,-smy_print_defaultsmasks passwords by default. Use this option to display passwords as cleartext.
- •
–verbose,-vVerbose mode. Print more information about what the program does.
- •
–version,-VDisplay version information and exit.
COPYRIGHT
Copyright © 1997, 2020, Oracle and/or its affiliates. All rights reserved.
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
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
Oracle Corporation (http://dev.mysql.com/).
