How To Install MySQL 8 With Workbench On Windows 10
How To Install MySQL 8 With Workbench On Windows 10
March 18, 2020

Oracle provides the MSI installer to install MySQL Community Server on Windows. This post explains all the steps required to install MySQL Community Server 8 on Windows 10 using the MSI installer. The steps should be similar on other versions of Windows.

Notes: In order to follow this post, you must completely remove the previous installation of MySQL server installed using the installer if it's already installed on the system. You can follow How To Completely Remove MySQL 5.7 From Windows to completely remove the previous installation done using the installer.

You may also be interested in other MySQL specific tutorials including How To Install MySQL 8 on Ubuntu and Learn Basic SQL Queries Using MySQL.

Step 1 - Download Installer

The MSI installers are available on the official site to install MySQL Community Server edition on Windows. The download is available for either online or offline mode. We will download and install the server using the offline download having the larger size to install the selected apps locally with the latest version as shown in Fig 1. The MySQL version available while writing this tutorial was 8.0.19 as shown in Fig 1.

Download MySQL 8

Fig 1

The next page asks to either log in and start the download or download it directly as shown in Fig 2.

MySQL 8 Download Options

Fig 2

Complete the download by following either of the approaches.

Step 2 - Install MySQL

Double click the installer to execute it. It will show the default installation options as shown in Fig 3.

MySQL 8 Install Options

Fig 3

I have selected the Custom Option to manually choose the products to be installed on my system as shown in Fig 4.

MySQL 8 Install Custom

Fig 4

Now click on the Next Button to continue the installation. The next screen shows the options to select the products as shown in Fig 5. I have selected the required products including the Server, Workbench, and Notifier which might differ in your case. You may also choose the MySQL Shell to execute the queries using MySQL Shell.

MySQL 8 Install Products

Fig 5

Click the Next Button to continue the installation. The Check Requirements Screen shows the options to check for the Visual C++ Redistributable Package as shown in Fig 6.

MySQL 8 Install Requirements Check

Fig 6

Click the Execute Button to install the C++ Package to meet the requirements. It will install the package and update the status as shown in Fig 7.

MySQL 8 Install Requirements

Fig 7

Now click the Next Button to continue the installation. The Installation Screen shows all the products selected by us in the previous steps as shown in Fig 8.

MySQL 8 Install Products

Fig 8

Now click the Execute Button to start installing the selected products. It will show the installation progress as shown in Fig 9.

MySQL 8 Install Progress

Fig 9

The installer will mark the product installation as complete as shown in Fig 10 and enable the Next Button to finalize the installation as shown in Fig 10.

MySQL 8 Install Complete

Fig 10

Click the Next Button and the installer shows screen having the message to start the configuration of applicable applications as shown in Fig 11.

MySQL 8 Install Configure

Fig 11

Now click the Next Button to start the configuration. The next screen shows options to configure MySQL server either as a standalone server with classic replication strategy or InnoDB Cluster as shown in Fig 12.

MySQL 8 Install Availability

Fig 12

We have selected the standalone option to keep the installation simple without using advanced cluster options for this tutorial. Click the Next Button and the next screen shows options to choose server type and port as shown in Fig 13.

MySQL 8 Configure Server and Port

Fig 13

I have selected the option to show Advanced and Logging Options as highlighted in Fig 13. Now click the Next Button to continue the installation. The next screen shows options to choose the authentication method as shown in Fig 14. Though the newer options are good, in a certain situation these might not be fully supported, for now, hence I have selected the Legacy Authentication method. If you are sure about the usage, then select the recommended authentication method.

MySQL 8 Installation - Authentication Method

Fig 14

Now click the Next Button to configure the Accounts and Roles as shown in Fig 15.

MySQL 8 Installation - Accounts

Fig 15

Choose at least a medium strength password and add user accounts if required. Click the Next Button to configure windows service as shown in Fig 16.

MySQL 8 Installation - Service

Fig 16

Keep the default options as selected and click the Next Button. The next screen shows the logging options as shown in Fig 17.

MySQL 8 Installation - Logging

Fig 17

You may disable the Binary Logging to improve the performance if you know the impact on the type of usage on your system. Now click the Next Button to configure the Advanced Options as shown in Fig 18.

MySQL 8 Installation - Advanced Options

Fig 18

Keep the default options selected on click the Next Button. The next screen shows the configuration steps as shown in Fig 19.

MySQL 8 Installation - Apply Configuration

Fig 19

Click the Execute Button to apply the configurations. It will complete the configuration and add MySQL Notifier on the system tray as shown in Fig 20.

MySQL 8 Installation - Configured

Fig 20

Click the Finish Button to complete MySQL configuration. The next screen shows success messaged for the configurations as shown in Fig 21.

MySQL 8 Installation - Configured

Fig 21

Click the Next Button to continue. The next screen shows the success message and option to launch Workbench as shown in Fig 22.

MySQL 8 Installation - Completed

Fig 22

Click the Finish Button to complete the installation and launch Workbench. The next screen shows the Welcome Screen of Workbench with a default connection to the MySQL Server as shown in Fig 23.

MySQL Workbench 8 - Welcome

Fig 23

Click the default connection. It will ask for the password to login as shown in Fig 24.

MySQL Workbench 8 - Connect

Fig 24

Enter the password and click OK Button to connect with the MySQL Server. It will show the administration and default panels as shown in Fig 25.

MySQL Workbench 8 - Connected

Fig 25

Summary

In this tutorial, we have discussed to install MySQL Community Server 8 with Workbench using the MSI Installer provided by Oracle.

Write a Comment

Click on the captcha image to get new code.
Discussion Forum by DISQUS