my_print_defaults 显示选项文件中选项组存在的选项。输出指示读取指定选项组的程序使用了哪些选项。例如,mysqlcheck 程序会读取 [mysqlcheck] 和 [client] 选项组。要查看标准选项文件中这些组包含了哪些选项,可以像这样调用 my_print_defaults: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 支持以下选项。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--config-file=,file_name--defaults-file=,file_name-cfile_name只读取给定的选项文件。Read only the given option file.
--debug=debug_options,-# debug_options--debug=,debug_options-#debug_options写入调试日志。典型的
debug_options字符串是d:t:o,。默认值是file_named:t:o,/tmp/my_print_defaults.trace。Write a debugging log. A typicaldebug_optionsstring isd:t:o,. The default isfile_named:t:o,/tmp/my_print_defaults.trace.--defaults-extra-file=file_name,--extra-file=file_name,-e file_name--defaults-extra-file=,file_name--extra-file=,file_name-efile_name在全局选项文件之后(在 Unix 上在用户选项文件之前)读取此选项文件。Read this option file after the global option file but (on Unix) before the user option file.
有关此选项文件选项及其他选项文件选项的更多信息,请参见 第 6.2.2.3 节,“影响选项文件处理的命令行选项”。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--defaults-group-suffix=,suffix-gsuffix除了命令行中指定的组外,还读取具有给定后缀的组。In addition to the groups named on the command line, read groups that have the given suffix.
有关此选项文件选项及其他选项文件选项的更多信息,请参见 第 6.2.2.3 节,“影响选项文件处理的命令行选项”。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-lname从名为登录路径的
.mylogin.cnf登录路径文件中读取选项。“登录路径” 是一个选项组,包含指定要连接哪个 MySQL 服务器以及以哪个帐户进行身份验证的选项。要创建或修改登录路径文件,请使用 mysql_config_editor 工具。参见 第 6.6.7 节,“mysql_config_editor — MySQL 配置工具”。Read options from the named login path in the.mylogin.cnflogin 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 Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”.有关此选项文件选项及其他选项文件选项的更多信息,请参见 第 6.2.2.3 节,“影响选项文件处理的命令行选项”。For additional information about this and other option-file options, see Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”.
跳过从登录路径文件读取选项。Skips reading options from the login path file.
有关信息,请参见
--login-path。See--login-pathfor related information.有关此选项文件选项及其他选项文件选项的更多信息,请参见 第 6.2.2.3 节,“影响选项文件处理的命令行选项”。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.
有关此选项文件选项及其他选项文件选项的更多信息,请参见 第 6.2.2.3 节,“影响选项文件处理的命令行选项”。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,-smy_print_defaults 默认会屏蔽密码。使用此选项可以以明文显示密码。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.