Install MySQL service under Windows via MySQL Installer

MySQL official provides the installer way to install MySQL service as well as other components, so that the installation of Windows, uninstall, configuration MySQL becomes particularly simple.

1. Preparing for installation 1.1 preparing the MySQL installation package

Windows version installation package download

Baidu Cloud Disk share installation package download password: jmj2

1.2 Checking the operating system type

Check the operating system type primarily to understand whether the system is: 32-bit operating system (x86) or 64-bit operating system (x64)

1.3 Check if the system has MySQL installed

If MySQL is already installed on the system then it is recommended to reinstall after a full uninstall.

2. Start Installation 2.1 Execute the installation package

After the installation package is executed, the system will have some security blocking reminders, agree to it, then agree to the license and proceed to the next step.

2.2 Select the installation type

• Developer Default: The developer defaults to installing all the products required for MySQL development and is not recommended

• Server only: Install only MySQL services, typically in the deployment of MySQL services using

• Client only: Install MySQL client only

• Full: Install all the products and features that MySQL contains

• Custom: User-defined installation,!!! This article uses user-defined installation

2.3 Selecting the installation products and features

Install the basic components to meet MySQL development, choose MySQL Server here, choose x86 or x64 according to the system type.

After you select, continue to the next step.

3. Start configuration

After completing the MySQL installation steps above, you need to further configure the MySQL service.

3.1 Configuration types and networks

The MySQL installation package gives us the best configuration by default, where the configuration remains the default, next step.

3.2 Configuring the account password

After the MySQL installation is complete, you need to set the password for the root user, after the password setting is complete, it is important to remember that the password must be used for subsequent access to the MySQL service by the root user.

3.3 Configuring the MySQL Service

MySQL as a service program, set it to Windows service and turn on auto-start.

3.4 Execution Configuration takes effect

The configuration to fill in each step above does not really take effect, you need to perform the following steps to make the configuration take effect.

4. Use MySQL4.1 to view the MySQL service under Windows

4.2 Connecting MySQL client via MySQL server

Connect MySQL service via MySQL command line client

The MySQL command line client will prompt for a password, where the password is the root user password that is set during configuration, and after the input is completed, the connection is successful.

Installing the MySQL service from MySQL installer under Windows