<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="alter-server">
      </a>
      15.1.8 ALTER SERVER Statement
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045189598528">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa2916297"><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">ALTER</span> <span class="token keyword">SERVER</span>  <em class="replaceable">server_name</em>
    <span class="token keyword">OPTIONS</span> <span class="token punctuation">(</span><span class="token keyword"><em class="replaceable">option</em></span> <span class="token punctuation">[</span><span class="token punctuation">,</span> <span class="token keyword"><em class="replaceable">option</em></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></code></pre>
  </div>
  <p>
   Alters the server information for
   <code class="literal">
    <em class="replaceable">
     <code>
      server_name
     </code>
    </em>
   </code>
   ,
      adjusting any of the options permitted in the
   <a class="link" href="create-server.html" title="15.1.18 CREATE SERVER Statement">
    <code class="literal">
     CREATE SERVER
    </code>
   </a>
   statement. The
      corresponding fields in the
   <code class="literal">
    mysql.servers
   </code>
   table
      are updated accordingly. This statement requires the
   <a class="link" href="privileges-provided.html#priv_super">
    <code class="literal">
     SUPER
    </code>
   </a>
   privilege.
  </p>
  <p>
   For example, to update the
   <code class="literal">
    USER
   </code>
   option:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa53002391"><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">ALTER</span> <span class="token keyword">SERVER</span> s <span class="token keyword">OPTIONS</span> <span class="token punctuation">(</span><span class="token keyword">USER</span> <span class="token string">'sally'</span><span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   <code class="literal">
    ALTER SERVER
   </code>
   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>
   <code class="literal">
    ALTER SERVER
   </code>
   is not written to the binary log,
      regardless of the logging format that is in use.
  </p>
 </div>
 <br/>
</div>
