<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="reset">
      </a>
      15.7.8.6 RESET Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045168375264">
  </a>
  <a class="indexterm" name="idm46045168374176">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa39287278"><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-sql"><span class="token keyword">RESET</span> <em class="replaceable">reset_option</em> <span class="token punctuation">[</span><span class="token punctuation">,</span> <em class="replaceable">reset_option</em><span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>

<em class="replaceable">reset_option</em>: {
    <span class="token datatype">BINARY</span> <span class="token keyword">LOGS</span> <span class="token operator">AND</span> GTIDS
  <span class="token operator">|</span> <span class="token keyword">REPLICA</span>
}</code></pre>
  </div>
  <p>
   The
   <a class="link" href="reset.html" title="15.7.8.6 RESET Statement">
    <code class="literal">
     RESET
    </code>
   </a>
   statement is used to
        clear the state of various server operations. You must have the
   <a class="link" href="privileges-provided.html#priv_reload">
    <code class="literal">
     RELOAD
    </code>
   </a>
   privilege to execute
   <a class="link" href="reset.html" title="15.7.8.6 RESET Statement">
    <code class="literal">
     RESET
    </code>
   </a>
   .
  </p>
  <p>
   For information about the
   <a class="link" href="reset-persist.html" title="15.7.8.7 RESET PERSIST Statement">
    <code class="literal">
     RESET
        PERSIST
    </code>
   </a>
   statement that removes persisted global system
        variables, see
   <a class="xref" href="reset-persist.html" title="15.7.8.7 RESET PERSIST Statement">
    Section 15.7.8.7, “RESET PERSIST Statement”
   </a>
   .
  </p>
  <p>
   <a class="link" href="reset.html" title="15.7.8.6 RESET Statement">
    <code class="literal">
     RESET
    </code>
   </a>
   acts as a stronger version
        of the
   <a class="link" href="flush.html" title="15.7.8.3 FLUSH Statement">
    <code class="literal">
     FLUSH
    </code>
   </a>
   statement. See
   <a class="xref" href="flush.html" title="15.7.8.3 FLUSH Statement">
    Section 15.7.8.3, “FLUSH Statement”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="reset.html" title="15.7.8.6 RESET Statement">
    <code class="literal">
     RESET
    </code>
   </a>
   statement causes an
        implicit commit. See
   <a class="xref" href="implicit-commit.html" title="15.3.3 Statements That Cause an Implicit Commit">
    Section 15.3.3, “Statements That Cause an Implicit Commit”
   </a>
   .
  </p>
  <p>
   The following list describes the permitted
   <a class="link" href="reset.html" title="15.7.8.6 RESET Statement">
    <code class="literal">
     RESET
    </code>
   </a>
   statement
   <em class="replaceable">
    <code>
     reset_option
    </code>
   </em>
   values:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="reset-binary-logs-and-gtids.html" title="15.4.1.2 RESET BINARY LOGS AND GTIDS Statement">
       <code class="literal">
        RESET BINARY LOGS AND GTIDS
       </code>
      </a>
     </p>
     <p>
      Deletes all binary logs listed in the index file, resets the
            binary log index file to be empty, and creates a new binary
            log file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="reset-replica.html" title="15.4.2.3 RESET REPLICA Statement">
       <code class="literal">
        RESET
            REPLICA
       </code>
      </a>
     </p>
     <p>
      Makes the replica forget its replication position in the
            source binary logs. Also resets the relay log by deleting
            any existing relay log files and beginning a new one.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
