<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="my-print-defaults">
      </a>
      6.7.2 my_print_defaults — Display Options from Option Files
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045302980416">
  </a>
  <p>
   <a class="link" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
    <span class="command">
     <strong>
      my_print_defaults
     </strong>
    </span>
   </a>
   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
   <a class="link" href="mysqlcheck.html" title="6.5.3 mysqlcheck — A Table Maintenance Program">
    <span class="command">
     <strong>
      mysqlcheck
     </strong>
    </span>
   </a>
   program reads the
   <code class="literal">
    [mysqlcheck]
   </code>
   and
   <code class="literal">
    [client]
   </code>
   option groups. To see what options are present in those groups
        in the standard option files, invoke
   <a class="link" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
    <span class="command">
     <strong>
      my_print_defaults
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa5510615"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal"><span class="token prompt">$&gt; </span><span class="token command">my_print_defaults</span> mysqlcheck client
<span class="token constant">--user</span><span class="token attr-value"><span class="token punctuation">=</span>myusername</span>
<span class="token constant">--password</span><span class="token attr-value"><span class="token punctuation">=</span><em class="replaceable">password</em></span>
<span class="token constant">--host</span><span class="token attr-value"><span class="token punctuation">=</span>localhost</span></code></pre>
  </div>
  <p>
   The output consists of options, one per line, in the form that
        they would be specified on the command line.
  </p>
  <p>
   <a class="link" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
    <span class="command">
     <strong>
      my_print_defaults
     </strong>
    </span>
   </a>
   supports the following
        options.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_help">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_help">
       <code class="option">
        --help
       </code>
      </a>
      ,
      <code class="option">
       -?
      </code>
     </p>
     <a class="indexterm" name="idm46045302966224">
     </a>
     <a class="indexterm" name="idm46045302964736">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_config-file">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_config-file">
       <code class="option">
        --config-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      ,
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_config-file">
       <code class="option">
        --defaults-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -c
       <em class="replaceable">
        <code>
         file_name
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045302958192">
     </a>
     <a class="indexterm" name="idm46045302956704">
     </a>
     <a class="indexterm" name="idm46045302955216">
     </a>
     <a class="indexterm" name="idm46045302953728">
     </a>
     <p>
      Read only the given option file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_debug">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_debug">
       <code class="option">
        --debug=
        <em class="replaceable">
         <code>
          debug_options
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -#
       <em class="replaceable">
        <code>
         debug_options
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045302948416">
     </a>
     <a class="indexterm" name="idm46045302946928">
     </a>
     <p>
      Write a debugging log. A typical
      <em class="replaceable">
       <code>
        debug_options
       </code>
      </em>
      string is
      <code class="literal">
       d:t:o,
       <em class="replaceable">
        <code>
         file_name
        </code>
       </em>
      </code>
      .
            The default is
      <code class="literal">
       d:t:o,/tmp/my_print_defaults.trace
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_defaults-extra-file">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_defaults-extra-file">
       <code class="option">
        --defaults-extra-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      ,
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_defaults-extra-file">
       <code class="option">
        --extra-file=
        <em class="replaceable">
         <code>
          file_name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -e
       <em class="replaceable">
        <code>
         file_name
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045302938000">
     </a>
     <a class="indexterm" name="idm46045302936496">
     </a>
     <a class="indexterm" name="idm46045302934992">
     </a>
     <a class="indexterm" name="idm46045302933504">
     </a>
     <p>
      Read this option file after the global option file but (on
            Unix) before the user option file.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_defaults-group-suffix">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix=
        <em class="replaceable">
         <code>
          suffix
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -g
       <em class="replaceable">
        <code>
         suffix
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045302926880">
     </a>
     <a class="indexterm" name="idm46045302925376">
     </a>
     <p>
      In addition to the groups named on the command line, read
            groups that have the given suffix.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_login-path">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_login-path">
       <code class="option">
        --login-path=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -l
       <em class="replaceable">
        <code>
         name
        </code>
       </em>
      </code>
     </p>
     <a class="indexterm" name="idm46045302918960">
     </a>
     <a class="indexterm" name="idm46045302917472">
     </a>
     <p>
      Read options from the named login path in the
      <code class="filename">
       .mylogin.cnf
      </code>
      login path file. A
      <span class="quote">
       “
       <span class="quote">
        login path
       </span>
       ”
      </span>
      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
      <a class="link" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       <span class="command">
        <strong>
         mysql_config_editor
        </strong>
       </span>
      </a>
      utility. See
      <a class="xref" href="mysql-config-editor.html" title="6.6.7 mysql_config_editor — MySQL Configuration Utility">
       Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
      </a>
      .
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_no-login-paths">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045302908736">
     </a>
     <a class="indexterm" name="idm46045302907248">
     </a>
     <p>
      Skips reading options from the login path file.
     </p>
     <p>
      See
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
      for related information.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_no-defaults">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
      ,
      <code class="option">
       -n
      </code>
     </p>
     <a class="indexterm" name="idm46045302899968">
     </a>
     <a class="indexterm" name="idm46045302898480">
     </a>
     <p>
      Return an empty string.
     </p>
     <p>
      For additional information about this and other option-file
            options, see
      <a class="xref" href="option-file-options.html" title="6.2.2.3 Command-Line Options that Affect Option-File Handling">
       Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_show">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_show">
       <code class="option">
        --show
       </code>
      </a>
      ,
      <code class="option">
       -s
      </code>
     </p>
     <a class="indexterm" name="idm46045302892656">
     </a>
     <a class="indexterm" name="idm46045302891168">
     </a>
     <p>
      <a class="link" href="my-print-defaults.html" title="6.7.2 my_print_defaults — Display Options from Option Files">
       <span class="command">
        <strong>
         my_print_defaults
        </strong>
       </span>
      </a>
      masks passwords by
            default. Use this option to display passwords as cleartext.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_verbose">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      ,
      <code class="option">
       -v
      </code>
     </p>
     <a class="indexterm" name="idm46045302885264">
     </a>
     <a class="indexterm" name="idm46045302883776">
     </a>
     <p>
      Verbose mode. Print more information about what the program
            does.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_my_print_defaults_version">
      </a>
      <a class="link" href="my-print-defaults.html#option_my_print_defaults_version">
       <code class="option">
        --version
       </code>
      </a>
      ,
      <code class="option">
       -V
      </code>
     </p>
     <a class="indexterm" name="idm46045302879072">
     </a>
     <a class="indexterm" name="idm46045302877584">
     </a>
     <p>
      Display version information and exit.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
