<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="option-defaults-equals">
      </a>
      6.2.2.6 Option Defaults, Options Expecting Values, and the = Sign
     </h4>
    </div>
   </div>
  </div>
  <p>
   By convention, long forms of options that assign a value are
        written with an equals (
   <code class="literal">
    =
   </code>
   ) sign, like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa44783281"><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">mysql <span class="token constant">--host</span><span class="token attr-value"><span class="token punctuation">=</span>tonfisk</span> <span class="token constant">--user</span><span class="token attr-value"><span class="token punctuation">=</span>jon</span></code></pre>
  </div>
  <p>
   For options that require a value (that is, not having a default
        value), the equal sign is not required, and so the following is
        also valid:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa45185826"><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">mysql <span class="token property">--host</span> tonfisk <span class="token property">--user</span> jon</code></pre>
  </div>
  <p>
   In both cases, the
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client attempts to
        connect to a MySQL server running on the host named
   <span class="quote">
    “
    <span class="quote">
     tonfisk
    </span>
    ”
   </span>
   using an account with the user name
   <span class="quote">
    “
    <span class="quote">
     jon
    </span>
    ”
   </span>
   .
  </p>
  <p>
   Due to this behavior, problems can occasionally arise when no
        value is provided for an option that expects one. Consider the
        following example, where a user connects to a MySQL server
        running on host
   <code class="literal">
    tonfisk
   </code>
   as user
   <code class="literal">
    jon
   </code>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa76328561"><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">mysql</span> <span class="token property">--host</span> 85<span class="token punctuation">.</span>224<span class="token punctuation">.</span>35<span class="token punctuation">.</span>45 <span class="token property">--user</span> jon
Welcome to the MySQL monitor<span class="token punctuation">.</span>  Commands end with <span class="token punctuation">;</span> or \g<span class="token punctuation">.</span>
Your MySQL connection id is 3
Server version<span class="token punctuation">:</span> 8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>3 Source distribution

Type <span class="token atrule">'help;'</span> or <span class="token atrule">'\h'</span> for help<span class="token punctuation">.</span> Type <span class="token atrule">'\c'</span> to clear the buffer<span class="token punctuation">.</span>

<span class="token prompt">mysql&gt;</span><span class="token command"> SELECT</span> CURRENT_USER<span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> CURRENT_USER() <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> jon@%          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Omitting the required value for one of these option yields an
        error, such as the one shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa21792931"><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">mysql</span> <span class="token property">--host</span> 85<span class="token punctuation">.</span>224<span class="token punctuation">.</span>35<span class="token punctuation">.</span>45 <span class="token property">--user</span>
mysql<span class="token punctuation">:</span> option <span class="token atrule">'--user'</span> requires an argument</code></pre>
  </div>
  <p>
   In this case,
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   was unable to find a
        value following the
   <a class="link" href="connection-options.html#option_general_user">
    <code class="option">
     --user
    </code>
   </a>
   option because nothing came after it on the command line.
        However, if you omit the value for an option that is
   <span class="emphasis">
    <em>
     not
    </em>
   </span>
   the last option to be used, you obtain
        a different error that you may not be expecting:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa97399641"><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">mysql</span> <span class="token property">--host</span> <span class="token property">--user</span> jon
<span class="token output">ERROR 2005 (HY000)<span class="token punctuation">:</span> Unknown MySQL server host '--user' (1)</span></code></pre>
  </div>
  <p>
   Because
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   assumes that any string
        following
   <a class="link" href="connection-options.html#option_general_host">
    <code class="option">
     --host
    </code>
   </a>
   on the command
        line is a host name,
   <a class="link" href="connection-options.html#option_general_host">
    <code class="option">
     --host
    </code>
   </a>
   <a class="link" href="connection-options.html#option_general_user">
    <code class="option">
     --user
    </code>
   </a>
   is interpreted as
   <a class="link" href="connection-options.html#option_general_host">
    <code class="option">
     --host=--user
    </code>
   </a>
   , and the client
        attempts to connect to a MySQL server running on a host named
   <span class="quote">
    “
    <span class="quote">
     --user
    </span>
    ”
   </span>
   .
  </p>
  <p>
   Options having default values always require an equal sign when
        assigning a value; failing to do so causes an error. For
        example, the MySQL server
   <a class="link" href="server-options.html#option_mysqld_log-error">
    <code class="option">
     --log-error
    </code>
   </a>
   option has the
        default value
   <code class="filename">
    <em class="replaceable">
     <code>
      host_name
     </code>
    </em>
    .err
   </code>
   ,
        where
   <em class="replaceable">
    <code>
     host_name
    </code>
   </em>
   is the name of the
        host on which MySQL is running. Assume that you are running
        MySQL on a computer whose host name is
   <span class="quote">
    “
    <span class="quote">
     tonfisk
    </span>
    ”
   </span>
   ,
        and consider the following invocation of
   <a class="link" href="mysqld-safe.html" title="6.3.2 mysqld_safe — MySQL Server Startup Script">
    <span class="command">
     <strong>
      mysqld_safe
     </strong>
    </span>
   </a>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa86831917"><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">mysqld_safe</span> &amp;
<span class="token punctuation">[</span>1<span class="token punctuation">]</span> 11699
<span class="token prompt">$&gt; </span><span class="token command">080112</span> 12<span class="token punctuation">:</span>53<span class="token punctuation">:</span>40 mysqld_safe Logging to <span class="token atrule">'/usr/local/mysql/var/tonfisk.err'</span><span class="token punctuation">.</span>
080112 12<span class="token punctuation">:</span>53<span class="token punctuation">:</span>40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
$&gt;</code></pre>
  </div>
  <p>
   After shutting down the server, restart it as follows:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa39068703"><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">mysqld_safe</span> <span class="token property">--log-error</span> &amp;
<span class="token punctuation">[</span>1<span class="token punctuation">]</span> 11699
<span class="token prompt">$&gt; </span><span class="token command">080112</span> 12<span class="token punctuation">:</span>53<span class="token punctuation">:</span>40 mysqld_safe Logging to <span class="token atrule">'/usr/local/mysql/var/tonfisk.err'</span><span class="token punctuation">.</span>
080112 12<span class="token punctuation">:</span>53<span class="token punctuation">:</span>40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
$&gt;</code></pre>
  </div>
  <p>
   The result is the same, since
   <a class="link" href="mysqld-safe.html#option_mysqld_safe_log-error">
    <code class="option">
     --log-error
    </code>
   </a>
   is not followed
        by anything else on the command line, and it supplies its own
        default value. (The
   <code class="literal">
    &amp;
   </code>
   character tells the
        operating system to run MySQL in the background; it is ignored
        by MySQL itself.) Now suppose that you wish to log errors to a
        file named
   <code class="filename">
    my-errors.err
   </code>
   . You might try
        starting the server with
   <code class="option">
    --log-error my-errors
   </code>
   ,
        but this does not have the intended effect, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa92125802"><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">mysqld_safe</span> <span class="token property">--log-error</span> my-errors &amp;
<span class="token punctuation">[</span>1<span class="token punctuation">]</span> 31357
<span class="token prompt">$&gt; </span><span class="token command">080111</span> 22<span class="token punctuation">:</span>53<span class="token punctuation">:</span>31 mysqld_safe Logging to <span class="token atrule">'/usr/local/mysql/var/tonfisk.err'</span><span class="token punctuation">.</span>
080111 22<span class="token punctuation">:</span>53<span class="token punctuation">:</span>32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
080111 22<span class="token punctuation">:</span>53<span class="token punctuation">:</span>34 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk<span class="token punctuation">.</span>pid ended

<span class="token punctuation">[</span>1<span class="token punctuation">]</span>+  Done                    <span class="token punctuation">.</span>/mysqld_safe <span class="token property">--log-error</span> my-errors</code></pre>
  </div>
  <p>
   The server attempted to start using
   <code class="filename">
    /usr/local/mysql/var/tonfisk.err
   </code>
   as the
        error log, but then shut down. Examining the last few lines of
        this file shows the reason:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa64018264"><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">tail</span> /usr/local/mysql/var/tonfisk<span class="token punctuation">.</span>err
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>22<span class="token punctuation">.</span>278034Z 0 <span class="token property"><span class="token punctuation">[</span>ERROR<span class="token punctuation">]</span></span> Too many arguments <span class="token punctuation">(</span>first extra is <span class="token atrule">'my-errors'</span><span class="token punctuation">)</span><span class="token punctuation">.</span>
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>22<span class="token punctuation">.</span>278059Z 0 <span class="token punctuation">[</span>Note<span class="token punctuation">]</span> Use <span class="token property">--verbose</span> <span class="token property">--help</span> to get a list of available options!
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>22<span class="token punctuation">.</span>278076Z 0 <span class="token property"><span class="token punctuation">[</span>ERROR<span class="token punctuation">]</span></span> Aborting
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>22<span class="token punctuation">.</span>279704Z 0 <span class="token punctuation">[</span>Note<span class="token punctuation">]</span> InnoDB<span class="token punctuation">:</span> Starting shutdown<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>23<span class="token punctuation">.</span>777471Z 0 <span class="token punctuation">[</span>Note<span class="token punctuation">]</span> InnoDB<span class="token punctuation">:</span> Shutdown completed<span class="token punctuation">;</span> log sequence number 2319086
2013-09-24T15<span class="token punctuation">:</span>36<span class="token punctuation">:</span>23<span class="token punctuation">.</span>780134Z 0 <span class="token punctuation">[</span>Note<span class="token punctuation">]</span> mysqld<span class="token punctuation">:</span> Shutdown complete</code></pre>
  </div>
  <p>
   Because the
   <a class="link" href="mysqld-safe.html#option_mysqld_safe_log-error">
    <code class="option">
     --log-error
    </code>
   </a>
   option supplies a default value, you must use an equal sign to
        assign a different value to it, as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa48839322"><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">mysqld_safe</span> <span class="token constant">--log-error</span><span class="token attr-value"><span class="token punctuation">=</span>my-errors</span> &amp;
<span class="token punctuation">[</span>1<span class="token punctuation">]</span> 31437
<span class="token prompt">$&gt; </span><span class="token command">080111</span> 22<span class="token punctuation">:</span>54<span class="token punctuation">:</span>15 mysqld_safe Logging to <span class="token atrule">'/usr/local/mysql/var/my-errors.err'</span><span class="token punctuation">.</span>
080111 22<span class="token punctuation">:</span>54<span class="token punctuation">:</span>15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

$&gt;</code></pre>
  </div>
  <p>
   Now the server has been started successfully, and is logging
        errors to the file
   <code class="filename">
    /usr/local/mysql/var/my-errors.err
   </code>
   .
  </p>
  <p>
   Similar issues can arise when specifying option values in option
        files. For example, consider a
   <code class="filename">
    my.cnf
   </code>
   file
        that contains the following:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa47793027"><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-ini"><span class="token selector">[mysql]</span>

<span class="token constant">host</span>
<span class="token constant">user</span></code></pre>
  </div>
  <p>
   When the
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client reads this file, these
        entries are parsed as
   <a class="link" href="mysql-command-options.html#option_mysql_host">
    <code class="option">
     --host
    </code>
   </a>
   <a class="link" href="mysql-command-options.html#option_mysql_user">
    <code class="option">
     --user
    </code>
   </a>
   or
   <a class="link" href="mysql-command-options.html#option_mysql_host">
    <code class="option">
     --host=--user
    </code>
   </a>
   , with the result
        shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa49341005"><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">mysql</span>
<span class="token output">ERROR 2005 (HY000)<span class="token punctuation">:</span> Unknown MySQL server host '--user' (1)</span></code></pre>
  </div>
  <p>
   However, in option files, an equal sign is not assumed. Suppose
        the
   <code class="filename">
    my.cnf
   </code>
   file is as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa2341676"><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-ini"><span class="token selector">[mysql]</span>

user jon</code></pre>
  </div>
  <p>
   Trying to start
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   in this case causes a
        different error:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa68792210"><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">mysql</span>
mysql<span class="token punctuation">:</span> unknown option <span class="token atrule">'--user jon'</span></code></pre>
  </div>
  <p>
   A similar error would occur if you were to write
   <code class="literal">
    host
        tonfisk
   </code>
   in the option file rather than
   <code class="literal">
    host=tonfisk
   </code>
   . Instead, you must use the equal
        sign:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa26978338"><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-ini"><span class="token selector">[mysql]</span>

<span class="token constant">user</span><span class="token attr-value"><span class="token punctuation">=</span>jon</span></code></pre>
  </div>
  <p>
   Now the login attempt succeeds:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa60260027"><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">mysql</span>
Welcome to the MySQL monitor<span class="token punctuation">.</span>  Commands end with <span class="token punctuation">;</span> or \g<span class="token punctuation">.</span>
Your MySQL connection id is 5
Server version<span class="token punctuation">:</span> 8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>3 Source distribution

Type <span class="token atrule">'help;'</span> or <span class="token atrule">'\h'</span> for help<span class="token punctuation">.</span> Type <span class="token atrule">'\c'</span> to clear the buffer<span class="token punctuation">.</span>

<span class="token prompt">mysql&gt;</span><span class="token command"> SELECT</span> USER<span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> USER()        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> jon@localhost <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   This is not the same behavior as with the command line, where
        the equal sign is not required:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa57383363"><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">mysql</span> <span class="token property">--user</span> jon <span class="token property">--host</span> tonfisk
Welcome to the MySQL monitor<span class="token punctuation">.</span>  Commands end with <span class="token punctuation">;</span> or \g<span class="token punctuation">.</span>
Your MySQL connection id is 6
Server version<span class="token punctuation">:</span> 8<span class="token punctuation">.</span>4<span class="token punctuation">.</span>3 Source distribution

Type <span class="token atrule">'help;'</span> or <span class="token atrule">'\h'</span> for help<span class="token punctuation">.</span> Type <span class="token atrule">'\c'</span> to clear the buffer<span class="token punctuation">.</span>

<span class="token prompt">mysql&gt;</span><span class="token command"> SELECT</span> USER<span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> USER()        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> jon@tonfisk   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Specifying an option requiring a value without a value in an
        option file causes the server to abort with an error.
  </p>
 </div>
 <br/>
</div>
