Mysql 5.7.10 installation and configuration method graphic tutorial, mysql5.7.10

Mysql 5.7.10 installation and configuration method graphic tutorial, mysql5.7.10

Download, install, and configure MySQL5.7.10

1. Download

Since the MySQL version was upgraded to MySQL 5.7, the installation and configuration process has greatly changed from the original version. The following describes the download, installation, and configuration process of MySQL 5.7.

Figure 1.1 MySQL5.7

Currently, MySQL provides two different versions for different users:

MySQL Community Server: Community edition. This version is free of charge, but it does not provide official technical support.

MySQL Enterprise Server: Enterprise Edition, which provides cost-effective data warehouse applications, ACID transaction processing, and complete commit, rollback, crash recovery, and row-Level Lock functions. However, this version is billed and officially provides technical support such as telephone and documentation.

The latest MySQL version is MySQL 5.7, which can be downloaded on the official website (http://dev.mysql.com/downloads. On the MySQL official website, as shown in 1.2, click the "MySQL Installer 5." hyperlink in the lower-right corner. Then, follow the prompts to download the MySQL software to your local computer. Note that the database version is Windows (x86, 32-bit) and MSI Installer, as shown in Figure 1.3.

 

Figure 1.2 official MySQL website

Figure 1.3 select MySQL

Ii. Installation

After the MySQL download is complete, find the file downloaded to the local device and follow the steps below to install it by double-clicking:

Step 1: double-click the MySQL Installer (mysql-installer-community-5.7.10) and a welcome window, as shown in 1.4, will pop up.

Figure 1.4 welcome page for MySQL

Step 2:Click the "Install MySQL Products" text in Figure 1.4. The User License Agreement window is displayed, as shown in Figure 1.5.

Fig 1.5 User License Agreement window

Step 3:Select the select box in front of "I accept the license terms" and click the Next button to go to the select version and feature page, as shown in 1.6:

Step 4:Click Mysql Servers-> Mysql Server 5.7-> Mysql Server5.7.10-64-> Add to the box on the right and [Next]. The Next step is shown in Figure 1.7.

Figure 1.7 prepare for initialization

Step 5:After direct Execute initialization, the status changes to 1.8.

Figure 1.8 complete Initialization

Step 6:Click Next to enter 1.9, as shown in figure.

Figure 1.9 configuration preparation

Step 7:Click Next, as shown in Figure 2.0.

Figure 2.0 Configure port number

Step 8:Click Next after configuration, as shown in figure 2.1.

Figure 2.1 configure Password

Step 9:In the interface corresponding to figure 2.1, we need to set the password of the root user, in "MySQL Root Password" (enter the new password) and "Repeat Password" (OK) enter the expected password in the two edit boxes. You can also click Add User to Add a new User. Click the Next button on the left of the effect, as shown in figure 2.2.

Figure 2.2 Windows service configuration

Step 10:Click Next, as shown in Figure 2.3.

Figure 2.3 apply for service configuration

Step 11:Click Execute to start configuration. If the following 2.4 dialog box is displayed during configuration

Fig 2.4

Click OK

After configuration, the effect is shown in Figure 2.5.

Figure 2.5 service-related auxiliary functions configured

Step 12:Click Finish. Figure 2.6 shows the effect.

Figure 2.6 configure

Step 13:Click Next, as shown in Figure 2.7.

Figure 2.7 installation completed

Step 14:Click Finish.

Iii. Configuration 

1. Add Environment Variables

Variable name: MYSQL_HOME

Variable value: C: \ Program Files \ MySQL Server 5.7

That is, the installation directory of mysql. See Figure 2.8.

 

Fig 2.8

Add % MYSQL_HOME % \ bin in Path, as shown in Figure 2.9.

 

Fig 2.9

2. Register windows Services

Register mysql as a windows system service

The procedure is as follows:

1) log on to the bin directory under the MySQL extract directory from the console (note that cmd should be run as Administrator): As shown in Figure 3.0

Fig 3.0

2) enter the service installation command:

Mysqld install MySQL -- default-file = "C: \ Program Files \ mysql \ my-default.ini"

After the installation is successful, a message indicating successful service installation is displayed, as shown in Figure 3.1.

Note: The my-default.ini file is in the root directory after MySQL decompression, if not, can be obtained from other places.

Fig 3.1

Command: mysqld remove

3. Start the MySQL Service

Method 1:

Run the following command to start the service: net start mysql, as shown in Figure 3.2.

Fig 3.2

Method 2:

Open the management tools service and find the MySQL service.

Right-click Start or click Start on the left to start the service.

4. Modify the password of the root account

When the installation is complete, the default password of the root account is blank. You can change the password to the specified password. Example: 123456

Method 1:

c:>mysql –urootmysql>show databases; mysql>use mysql;mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';mysql>FLUSH PRIVILEGES;mysql>QUIT

Method 2:

Use a third-party management tool to change the password. For example, Navicat for MySQL

The above is how to install and configure mysql 5.7.10, and I hope it will help you learn it.