Upgrade Embedded MYSQL 5.7 to MYSQL 8.4.5

Notice

It is recommended to upgrade to MySQL 8.4.5 under the Support team's guidance.

Background

Starting with the Zephyr Enterprise 8.5 release, MySQL 8.0.x is officially replaced with MySQL 8.4.5. MySQL 8.0.x will still work as required with ZE before the upgrade. However, before upgrading to ZE version 8.5 or any later version, upgrade your embedded MySQL to version 8.4.5. After updating MySQL, follow the standard Zephyr upgrade process to complete the upgrade to version 8.5 or any later version.

Currently, upgrades to embedded MySQL are available through ZE Installer. However, it must be done manually before upgrading to ZE 8.5 or above.

Note

Embedded MySQL is only supported by Windows OS.

Operating System - Windows 10

Prerequisites

  1. This is for users who use embedded MySQL for their production environment.

  2. MySQL 8.0.x connection should work properly with ZE (before the upgrade).

  3. Requirement or need of a user to upgrade to ZE 8.5 or above versions.

  4. Must upgrade the embedded MySQL before upgrading ZE to v8.5.

Upgrade Steps

A user must follow the steps before upgrading:

  1. Take a backup of the ZEPHYR Installation folder.

  2. Take a Database backup of ITCC and DIVERSION.

  3. The client will take downtime as per their policy for the production environment.

  4. Stop the services on Windows.

    As Zephyr, ES, and DB are installed as services on Windows, you must stop them in the following sequence:

    1. Stop Zephyr service

    2. Stop the Elasticsearch service

    3. Stop Database service

  5. Download MySQL v8.4.5 in ZIP format from the official MySQL website : https://downloads.mysql.com/archives/get/p/23/file/mysql-8.4.5-winx64.zip.

  6. Unzip the MySQL v8.4.5 ZIP file in any of your chosen directories.

  7. COPY the sub-folders below one by one from the unzipped MySQL 8.4.5 folder.

    1. bin/

    2. docs/

    3. include/

    4. lib/

    5. Share/

  8. PASTE the sub-folders one by one under <ZEPHYR-Installation-Directory>\mysql\

    For example, C:\Program Files\Zephyr\mysql\.

    Warning

    Do not remove any Target folders in C:\Program Files\Zephyr\mysql\ before copying the above folders. Important Config files are in the target folders.

  9. Go to the MySQL bin directory C:\Program Files\Zephyr\mysql\bin\.

    1. Check the MySQL version using the command below:

      MySQL --version

    2. Generally, MySQL 8.4.5 requires an MSVCP140.dll and MSVCP140_1.dll as a prerequisite

      1. If the above .dll file exists, it shows the new MySQL version as 8.4.5.

      2. If the above .dll file does not exist., Then it might show the following error.

        3629383998.png
        ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';
ALTER USER 'root'@'::1' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '<yourpassword>';

  10. Start all stopped services in the order:

    • Start the Database service.

    • Start ES service

  11. Follow the Zephyr upgrade process to v8.5.

In this section:
© 2025
Publication date: