<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="windows-upgrading">
      </a>
      3.11 Upgrading MySQL on Windows
     </h2>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045325928096">
  </a>
  <p>
   To upgrade MySQL on Windows, either
   <a class="link" href="windows-upgrading.html#windows-upgrading-msi" title="Upgrading MySQL with MSI">
    download and execute the
      latest MySQL Server MSI
   </a>
   or
   <a class="link" href="windows-upgrading.html#windows-upgrading-zip-distribution" title="Upgrading MySQL Using the Windows ZIP Distribution">
    use the Windows
      ZIP archive distribution
   </a>
   .
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    Unlike MySQL 8.4, MySQL 8.0 uses MySQL Installer to install
        and upgrade MySQL Server along with most other MySQL products;
        but MySQL Installer is not available with MySQL 8.1 and higher. However,
        the configuration functionality used in MySQL Installer is available as of
        MySQL 8.1 using
    <a class="xref" href="mysql-configurator.html" title="2.3.2 Configuration: Using MySQL Configurator">
     Section 2.3.2, “Configuration: Using MySQL Configurator”
    </a>
    that is
        bundled with both the MSI and Zip archive.
   </p>
  </div>
  <p>
   The approach you select depends on how the existing installation
      was performed. Before proceeding, review
   <a class="xref" href="upgrading.html" title="Chapter 3 Upgrading MySQL">
    Chapter 3,
    <i>
     Upgrading MySQL
    </i>
   </a>
   for additional information on
      upgrading MySQL that is not specific to Windows.
  </p>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h3 class="title">
       <a name="windows-upgrading-msi">
       </a>
       Upgrading MySQL with MSI
      </h3>
     </div>
    </div>
   </div>
   <p>
    Download and execute the latest MSI. Although upgrading between
        release series is not directly supported, the "Custom Setup"
        option allows defining an installation location as otherwise the
        MSI installs to the standard location, such as
    <code class="filename">
     C:\Program Files\MySQL\MySQL Server
        8.4\
    </code>
    .
   </p>
   <p>
    Execute
    <a class="link" href="mysql-configurator.html" title="2.3.2 Configuration: Using MySQL Configurator">
     MySQL
        Configurator
    </a>
    to configure your installation.
   </p>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h3 class="title">
       <a name="windows-upgrading-zip-distribution">
       </a>
       Upgrading MySQL Using the Windows ZIP Distribution
      </h3>
     </div>
    </div>
   </div>
   <p>
    To perform an upgrade using the Windows ZIP archive
        distribution:
   </p>
   <div class="orderedlist">
    <ol class="orderedlist" type="1">
     <li class="listitem">
      <p>
       Download the latest Windows ZIP Archive distribution of
            MySQL from
       <a class="ulink" href="https://dev.mysql.com/downloads/" target="_top">
        https://dev.mysql.com/downloads/
       </a>
       .
      </p>
     </li>
     <li class="listitem">
      <p>
       If the server is running, stop it. If the server is
            installed as a service, stop the service with the following
            command from the command prompt:
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa52674427"><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 command"> SC</span> STOP <em class="replaceable">mysqld_service_name</em></code></pre>
      </div>
      <p>
       Alternatively, use
       <span class="command">
        <strong>
         NET STOP
         <em class="replaceable">
          <code>
           mysqld_service_name
          </code>
         </em>
        </strong>
       </span>
       .
      </p>
      <p>
       If you are not running the MySQL server as a service, use
       <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
        <span class="command">
         <strong>
          mysqladmin
         </strong>
        </span>
       </a>
       to stop it. For example,
            before upgrading from MySQL 8.3 to
            8.4, use
       <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
        <span class="command">
         <strong>
          mysqladmin
         </strong>
        </span>
       </a>
       from
            MySQL 8.3 as follows:
      </p>
      <div class="copytoclipboard-wrapper">
       <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa46108012"><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.3\bin\mysqladmin"</span> <span class="token property">-u</span> root shutdown</code></pre>
      </div>
      <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
       <div class="admon-title">
        Note
       </div>
       <p>
        If the MySQL
        <code class="literal">
         root
        </code>
        user account has a
              password, invoke
        <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
         <span class="command">
          <strong>
           mysqladmin
          </strong>
         </span>
        </a>
        with the
        <code class="option">
         -p
        </code>
        option and enter the password when
              prompted.
       </p>
      </div>
     </li>
     <li class="listitem">
      <p>
       Extract the ZIP archive. You may either overwrite your
            existing MySQL installation (usually located at
       <code class="filename">
        C:\mysql
       </code>
       ), or install it into a
            different directory, such as
       <code class="literal">
        C:\mysql8
       </code>
       .
            Overwriting the existing installation is recommended.
      </p>
     </li>
     <li class="listitem">
      <p>
       Restart the server. For example, use the
       <span class="command">
        <strong>
         SC START
         <em class="replaceable">
          <code>
           mysqld_service_name
          </code>
         </em>
        </strong>
       </span>
       or
       <span class="command">
        <strong>
         NET START
         <em class="replaceable">
          <code>
           mysqld_service_name
          </code>
         </em>
        </strong>
       </span>
       command if you run MySQL as a service, or invoke
       <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
        <span class="command">
         <strong>
          mysqld
         </strong>
        </span>
       </a>
       directly otherwise.
      </p>
     </li>
     <li class="listitem">
      <p>
       If you encounter errors, see
       <a class="xref" href="windows-troubleshooting.html" title="2.3.4 Troubleshooting a Microsoft Windows MySQL Server Installation">
        Section 2.3.4, “Troubleshooting a Microsoft Windows MySQL Server Installation”
       </a>
       .
      </p>
     </li>
    </ol>
   </div>
  </div>
 </div>
 <br/>
</div>
