Upgrade MySQL Server on Windows

Overview

This tutorial outlines steps to upgrade MySQL database server on Windows 10 operating system. The MySQL installer wizard will be able to identify and install updates for the MySQL components.

First things first

Take a backup of existing databases and follow the below steps. mysqldump is the utility to take backup of existing databases.

To know the existing MySQL server database version, open command prompt and issue the following command:

\> mysql -V

Output

C:\>mysql -V
mysql Ver 8.0.20 for Win64 on x86_64 (MySQL Community Server – GPL)

Download Installer

Download the new version MySQL GA installer from the MySQL website.

https://dev.mysql.com/downloads/windows/installer/8.0.html

Update MySQL Server

Select Microsoft Windows from the Operating System drop-down.

Download the MySQL installer on to the machine. Click on the Save File button to download and save the installer.( Firefox browser)

MySQL Installer Save File Win10

Update MySQL components

Double click on the installer and run it. Select the MySQL database components that you want to update. The installer would detect the component that require upgrade.

The Installed tab displays the component current version. The upgrade version is displayed in the Upgrade To tab.

Select MySQL Upgrade Components Win10

Check on the check boxes of the respective components to upgrade. It’s recommended to select all the components to upgrade.

Apply Updates

Click on the Next > button to apply the updates to the components. The installer would update each component.

Select Products to Update MySQL

Click on Execute button to update the MySQL components. The update is finished when all the components Status fields are marked as Complete.

To know what updates are made under the hood, click on the Show Details > button. This will display the update log.

MySQL Update Complete

Config Upgrade Check

In this process the installer checks the system tables and data dictionary tables. This is to maintain data integrity during the upgrade. Apply the configuration and click on the Execute button.

Click on Finish button to close the wizard.

MySQL versions before update