Install MySQL 8 on windows system and configuration

By CodersDrive
17-Jun-2020
MySQL

Let's install the MySQL 8 DB server on a windows system and do the configuration as a development server.

Install MySQL 8 DB on Windows systems
Step-1 Download the MySQL installer

Download the latest stable version of MySQL installer from here. There will be two download links one will be mysql-installer-web-community-x.x.x.x.msi which will be less in size and is an online installer. The other one is mysql-installer-ommunity-x.x.x.msi which is an offilne installer and large in size.

You can download and install with any of the links but the first one requires internet to download the required files through out the installation process. In this tutorial offline installer is downloaded and installed.

Step-2 Start Installtion

When the installation begins it first asks for "setup type" as shown below. For developers select default option otherwise select as per your requirement.

mysql installation on windows

In some systems if any system requirements are not met the following screens appear, which require to be resolved manually. Otherwise also you can ignore the below screens and move forward.

mysql installation on windows mysql installation on windows

Now the actual installation begins after pressing "Execute" and progress can be seen product wise as below and success screen appears after all products are installed.

mysql installation on windows mysql installation on windows Step-3 Product Configuration

After installation it asks for configuration of its products as shown below. Click on "Next"

mysql configuration on windows

Under High Availability default option will be "Standard MySQL Server" which is sufficient for developers. Select "InnoDB Cluster" option if you want your DB to be installed as a part of Cluster. Select default option and click "Next"

mysql configuration on windows

Under Type and Networking just check for the default options here click "Next" for developers. If you want to change the access port of your DB you can change here.

mysql configuration on windows

From MySQL 8 onwards authentication has been improved based on strong SHA-256 based methods, this is the default option. Here if you are configuring DB for new application development then go for the default option. Otherwise if you are configuring DB for existing application Use Legacy Authentication Method based on your application compatibility.

mysql configuration on windows

Now cretae the Root password for your DB. You can aslo add users for DB access now itself or you can do it after logging in as root user.

mysql configuration on windows

Under Windows Service click "Next" with default options unless otherwise you want to restrict access to a particular User.

mysql configuration on windows

Now click on "Execute" to apply all our selected configurations to MySQL Server. After Configuration is done click "Finish".

mysql configuration on windows mysql configuration on windows

In the next step "MySQL Router" configuration will be done. But as we have not installed our DB as InnoDB cluster we will simply click "Next" and then "Finish".

mysql configuration on windows mysql configuration on windows

Next step will install Samples and Examples for our reference. Click on "Next". In the next screen provide your created credentials and click "Check". If your connection is succeeded click "Next".

mysql configuration on windows mysql configuration on windows

Now Apply the configuration by clicking "Execute". Once executed click on "Finish".

mysql configuration on windows mysql configuration on windows

Now you you can see the all products configuration status here. Click on "Next"

mysql configuration on windows

Now you can see the Installation Complete screen. You have successfully installed MySQL 8 DB on your windows system. Click on "Finish" will launch the MySQL Work Bench.

mysql configuration on windows Step-4 Login to MySQL Workbench and create Database. MySQL 8 Workbench

Now you can login to your MySQL server and can create DB. Thanks for reading this post.


MySQL Windows

Search blog..!

Connect with us