Shulou(Shulou.com)06/01 Report--

Let me tell you a little bit about installing MySQL services and components in MySQL Installer under Windows. Have you ever heard of similar topics before? If you are interested, let's take a look at this article about installing MySQL services and components using MySQL Installer under Windows. I believe it will be of some help to you after reading it.

1. Installation preparation 1.1 prepare the MySQL installation package

Baidu cloud disk shared installation package download password: jmj2

Download the installation package for windows version

1.2 check the operating system type

Check the operating system type mainly to know whether the system is a 32-bit operating system (x86) or a 64-bit operating system (x64)

1.3 check if MySQL is installed on the system

If MySQL is already installed on the system, it is recommended that you uninstall it completely and then reinstall it.

two。 Start installation of 2.0 QroomA

Before installing MySQL, here are a few possible problems.

Question-1

Problem: the installer requires the computer to have .Net Framework 4.5.2

Prompt message:

The solution is as follows:

Exit the installer

Download .net Framework 4.5.2 from Microsoft's official website

Install .net Framework 4.5.2, re-execute MySQL installer question-2

Problem: the MySQL program requires the computer to have Micrsoft Visual C++ 2015 Redistributable Package (x64)

Prompt message:

The solution is as follows:

Cancel the installer

Download Micrsoft Visual C++ 2015 Redistributable Package (x64) from Microsoft's official website

After the installation of Micrsoft Visual C++ 2015 Redistributable Package (x64), re-execute the MySQL installer 2.1 execute the installation package

After executing the installation package, the system will have some security prevention reminders, just agree, then agree to grant the license and proceed to the next step.

2.2 Select the installation type

Developer Default: developers install all the products needed for MySQL development by default, and it is not recommended to use them.

Server only: install only MySQL services, usually used when deploying MySQL services

Client only: install only the MySQL client

Full: install all products and features included in MySQL

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

2.3 choose to install products and features

To install the basic components that meet MySQL development, choose MySQL Server here and choose x86 or x64 depending on the system type.

After you have chosen, you can move on 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 type and network

The MySQL installation package provides us with the best configuration by default, and we can keep the default configuration here, all the way to the next step.

3.2 configure account password

After the MySQL installation is completed, you need to set a password for root users. After setting the password here, it is important to keep in mind that subsequent root users must use this password when accessing the MySQL service.

Configure the MySQL service

MySQL as a service program, set it to Windows service and turn on automatic startup.

3.4 execute the configuration to take effect

The configuration entered in each of the above steps does not really take effect. You need to perform the following steps to make the configuration effective.

4. Use MySQL4.1 to view MySQL services under Windows

4.2 connecting to MySQL services through MySQL Client

Connect to the MySQL service through the MySQL command line client

The MySQL command line client will be prompted to enter the password. The password here is the root user password set during the configuration process. After entering the password, enter, enter, and successfully connect as shown in the figure.

5. Extension 5.1 MySQL commands added to the PATH path

Find the installation path of MySQL under the windows platform (for example, the Windows 10 64-bit system is installed at C:\ Program Files\ MySQL\ MySQL Server 5.7 by default)

Add steps (similar to configuring Java environment variable type and configuring PATH under Linux)

5.2 use the MySQL command directly in the command line window

After configuring the MySQL command to the PATH path, you can execute the mysql-u root-p command to connect to the database service on any command-line window when accessing MySQL.

What do you think of this article about using MySQL Installer to install MySQL services and components under Windows? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.