<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="account-management-statements">
      </a>
      15.7.1 Account Management Statements
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="alter-user.html">
       15.7.1.1 ALTER USER Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="create-role.html">
       15.7.1.2 CREATE ROLE Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="create-user.html">
       15.7.1.3 CREATE USER Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="drop-role.html">
       15.7.1.4 DROP ROLE Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="drop-user.html">
       15.7.1.5 DROP USER Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="grant.html">
       15.7.1.6 GRANT Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="rename-user.html">
       15.7.1.7 RENAME USER Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="revoke.html">
       15.7.1.8 REVOKE Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="set-default-role.html">
       15.7.1.9 SET DEFAULT ROLE Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="set-password.html">
       15.7.1.10 SET PASSWORD Statement
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="set-role.html">
       15.7.1.11 SET ROLE Statement
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   MySQL account information is stored in the tables of the
   <code class="literal">
    mysql
   </code>
   system schema. This database and the
      access control system are discussed extensively in
   <a class="xref" href="server-administration.html" title="Chapter 7 MySQL Server Administration">
    Chapter 7,
    <i>
     MySQL Server Administration
    </i>
   </a>
   , which you should consult
      for additional details.
  </p>
  <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Important
   </div>
   <p>
    Some MySQL releases introduce changes to the grant tables to add
        new privileges or features. To make sure that you can take
        advantage of any new capabilities, update your grant tables to
        the current structure whenever you upgrade MySQL. See
    <a class="xref" href="upgrading.html" title="Chapter 3 Upgrading MySQL">
     Chapter 3,
     <i>
      Upgrading MySQL
     </i>
    </a>
    .
   </p>
  </div>
  <p>
   When the
   <a class="link" href="server-system-variables.html#sysvar_read_only">
    <code class="literal">
     read_only
    </code>
   </a>
   system
      variable is enabled, account-management statements require the
   <a class="link" href="privileges-provided.html#priv_connection-admin">
    <code class="literal">
     CONNECTION_ADMIN
    </code>
   </a>
   privilege (or the
      deprecated
   <a class="link" href="privileges-provided.html#priv_super">
    <code class="literal">
     SUPER
    </code>
   </a>
   privilege), in
      addition to any other required privileges. This is because they
      modify tables in the
   <code class="literal">
    mysql
   </code>
   system schema.
  </p>
  <p>
   Account management statements are atomic and crash safe. For more
      information, see
   <a class="xref" href="atomic-ddl.html" title="15.1.1 Atomic Data Definition Statement Support">
    Section 15.1.1, “Atomic Data Definition Statement Support”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
