<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-connection-control-failed-login-attempts-table">
      </a>
      28.6.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076002624">
  </a>
  <p>
   This table provides information about the current number of
      consecutive failed connection attempts per account (user/host
      combination).
  </p>
  <p>
   <a class="link" href="information-schema-connection-control-failed-login-attempts-table.html" title="28.6.2 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table">
    <code class="literal">
     CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
    </code>
   </a>
   has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       USERHOST
      </code>
     </p>
     <p>
      The user/host combination indicating an account that has
          failed connection attempts, in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
       '@'
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
       '
      </code>
      format.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       FAILED_ATTEMPTS
      </code>
     </p>
     <p>
      The current number of consecutive failed connection attempts
          for the
      <code class="literal">
       USERHOST
      </code>
      value. This counts all
          failed attempts, regardless of whether they were delayed. The
          number of attempts for which the server added a delay to its
          response is the difference between the
      <code class="literal">
       FAILED_ATTEMPTS
      </code>
      value and the
      <a class="link" href="connection-control-variables.html#sysvar_connection_control_failed_connections_threshold">
       <code class="literal">
        connection_control_failed_connections_threshold
       </code>
      </a>
      system variable value.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045075989824">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      The
      <code class="literal">
       CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
      </code>
      plugin must be activated for this table to be available, and
          the
      <code class="literal">
       CONNECTION_CONTROL
      </code>
      plugin must be
          activated or the table contents are always empty. See
      <a class="xref" href="connection-control.html" title="8.4.2 The Connection-Control Plugins">
       Section 8.4.2, “The Connection-Control Plugins”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The table contains rows only for accounts that have had one or
          more consecutive failed connection attempts without a
          subsequent successful attempt. When an account connects
          successfully, its failed-connection count is reset to zero and
          the server removes any row corresponding to the account.
     </p>
    </li>
    <li class="listitem">
     <p>
      Assigning a value to the
      <a class="link" href="connection-control-variables.html#sysvar_connection_control_failed_connections_threshold">
       <code class="literal">
        connection_control_failed_connections_threshold
       </code>
      </a>
      system variable at runtime resets all accumulated
          failed-connection counters to zero, which causes the table to
          become empty.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
