Installing MySQL on Microsoft Windows

MySQLMySQLi Database

Let us understand how MySQL can be installed on Microsoft Windows −

MySQL is available for Microsoft Windows 64-bit operating systems only. To see the supported Windows platform information, visit https:// www.mysql.com/support/supportedplatforms/database.html.

There are different methods to install MySQL on Microsoft Windows. One of them is the MySQL Instasller Method. Let us see how this can be used.

It is considered as the simplest and recommended method to download MySQL Installer for Windows. It will install and configure a specific version of MySQL Server by following the below steps −

The first step is to download MySQL Installer from https://dev.mysql.com/downloads/installer/

Once this is done, execute the file.

Unlike the standard MySQL Installer, the smaller web−community version doesn’t bundle any MySQL applications, but it downloads the MySQL products that the user chooses to install. The setup type that needs to be used for the initial installation of MySQL products needs to be determined.

Let us see the below screenshot for Setup Type and understand this −

Developer Default

It provides a setup type which includes the selected version of MySQL Server and other MySQL tools that are related to MySQL development, like the MySQL Workbench.

Server Only

It provides a setup for the selected version of MySQL Server without other products.

Custom

It enables the user to select any version of MySQL Server and other MySQL products.

The next step is to install the server instance as well as the products −

Drag the products from “Ävaiable Products” section and drop in the right section

The next step is to begin the server configuration by selecting one of the following levels of availability for the server instance −

Standalone MySQL Server / Classic MySQL Replication (default)

This will configure a server instance to run without high availability.

InnoDB cluster

It will provide two configuration options based on MySQL Group Replication to −

  • Configure multiple server instances in a sandbox InnoDB Cluster on the local host for testing purposes only.

  • Create a new InnoDB Cluster and configure one seed instance or add a new server instance to an existing InnoDB Cluster.

The configuration process needs to be completed by following the onscreen instructions.

MySQL is now installed.

If MySQL is configured as a service, then Windows will automatically starts the MySQL server every time the system is restarted.

The above mentioned process also installs the MySQL Installer application on the local host, which can be used further to upgrade or reconfigure MySQL server.

raja
Published on 08-Mar-2021 11:47:20
Advertisements