- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
Installing MySQL on Microsoft Windows
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 −
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.
It provides a setup for the selected version of MySQL Server without other products.
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.
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.
- Related Articles
- Installing Python on Windows
- Installing MySQL on macOS
- Installing MySQL on Linux
- Installing MySQL on Solaris
- Installing MySQL on FreeBSD
- Installing SAP Sybase client on Windows server 2012 R2
- How to install Matplotlib without installing Qt using Conda on Windows?
- Installing MySQL from source on linux
- Microsoft, Device Health for Windows 8.1
- Upgrading MySQL on Windows
- Installing MySQL on Unix/Linux Using Generic Binaries
- Installing MySQL from Source
- Installing Python on Linux
- Installing a MySQL Source Distribution
- Installing Python on Mac OS