<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="windows-testing">
      </a>
      2.3.3.9 Testing The MySQL Installation
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045331880240">
  </a>
  <a class="indexterm" name="idm46045331879200">
  </a>
  <p>
   You can test whether the MySQL server is working by executing
        any of the following commands:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa76860232"><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">C:\&gt;</span> <span class="token atrule">"C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqlshow"</span>
<span class="token prompt">C:\&gt;</span> <span class="token atrule">"C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqlshow"</span> <span class="token property">-u</span> root mysql
<span class="token prompt">C:\&gt;</span> <span class="token atrule">"C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqladmin"</span> version status proc
<span class="token prompt">C:\&gt;</span> <span class="token atrule">"C:\Program Files\MySQL\MySQL Server 8.4\bin\mysql"</span> test</code></pre>
  </div>
  <p>
   If
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   is slow to respond to TCP/IP
        connections from client programs, there is probably a problem
        with your DNS. In this case, start
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   with the
   <a class="link" href="server-system-variables.html#sysvar_skip_name_resolve">
    <code class="literal">
     skip_name_resolve
    </code>
   </a>
   system variable enabled and use only
   <code class="literal">
    localhost
   </code>
   and IP addresses in the
   <code class="literal">
    Host
   </code>
   column of the MySQL grant tables. (Be
        sure that an account exists that specifies an IP address or you
        may not be able to connect.)
  </p>
  <p>
   You can force a MySQL client to use a named-pipe connection
        rather than TCP/IP by specifying the
   <a class="link" href="connection-options.html#option_general_pipe">
    <code class="option">
     --pipe
    </code>
   </a>
   or
   <a class="link" href="connection-options.html#option_general_protocol">
    <code class="option">
     --protocol=PIPE
    </code>
   </a>
   option, or by
        specifying
   <code class="literal">
    .
   </code>
   (period) as the host name. Use
        the
   <a class="link" href="connection-options.html#option_general_socket">
    <code class="option">
     --socket
    </code>
   </a>
   option to specify
        the name of the pipe if you do not want to use the default pipe
        name.
  </p>
  <p>
   If you have set a password for the
   <code class="literal">
    root
   </code>
   account, deleted the anonymous account, or created a new user
        account, then to connect to the MySQL server you must use the
        appropriate
   <code class="option">
    -u
   </code>
   and
   <code class="option">
    -p
   </code>
   options
        with the commands shown previously. See
   <a class="xref" href="connecting.html" title="6.2.4 Connecting to the MySQL Server Using Command Options">
    Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
   </a>
   .
  </p>
  <p>
   For more information about
   <a class="link" href="mysqlshow.html" title="6.5.6 mysqlshow — Display Database, Table, and Column Information">
    <span class="command">
     <strong>
      mysqlshow
     </strong>
    </span>
   </a>
   , see
   <a class="xref" href="mysqlshow.html" title="6.5.6 mysqlshow — Display Database, Table, and Column Information">
    Section 6.5.6, “mysqlshow — Display Database, Table, and Column Information”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
