Install MySQL on Microsoft Windows

Let us know how to install MySQL on Microsoft Windows -

MySQL is only available on Microsoft Windows 64-bit operating system. To view supported Windows platform information, visit https://www.mysql.com/support/supportedplatforms/database.html.

There are several ways to install MySQL on Microsoft Windows. One of them is the MySQL Instasller method. Let's see how to use it.

It is considered the easiest and recommended way to download the MySQL installer for Windows. It will follow the following steps to install and configure a specific version of MySQL server -

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

After completion, execute the file.

Unlike the standard MySQL installer, the Smaller Network Community Edition does not bundle any MySQL applications, but it does download the MySQL products the user chooses to install. You need to determine the type of installation you will use for your initial installation of your MySQL product.

Let’s look at the installation type screenshot below and understand this -

Developer Default

It provides a Installation type, which includes the selected version of MySQL Server and other MySQL tools related to MySQL development, such as MySQL Workbench.

Server Only

It provides setup for selected versions of MySQL Server, no other products are required.

Customization

It enables users to choose any version of MySQL Server and other MySQL products.

The next step is to install the server instance along with the products -

#Drag and drop the products from the "avaiable Products" section to the right section

The next step is to start the server configuration by selecting one of the server instance availability levels as follows:

Standalone MySQL Server/Classic MySQL Replication (Default)

This configures the server instance to run without high availability.

InnoDB Cluster

It will provide two configuration options based on MySQL Group Replication -

• Configure multiple server instances locally in sandbox InnoDB The cluster on the host is for testing purposes only.

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

The configuration process needs to be completed by following the on-screen instructions.

MySQL is now installed.

If MySQL is configured as a service, Windows will automatically start the MySQL server every time the system restarts.

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

The above is the detailed content of Install MySQL on Microsoft Windows. For more information, please follow other related articles on the PHP Chinese website!