Install and configure MySQL 5.6 in Windows

I. Preparations before installation

1. Download the installation package from the official MySQL website www.mysql.com. 1-1:

Figure 1-1

The downloaded Installation File is as follows:

Figure 1-2

Ii. Installation

1. Double-click the downloaded installation file. The MySQL version installed in this blog is 5.6.10.1, and the page 1-3 is displayed:

 

Figure 1-3

2. Click "Install ".MySQLProducts to go to the 1-4 Page:

 

Figure 1-4

3. Select "I"AcceptTheLicenseAfter "terms", click "Next". The update page for the latest product is displayed from 1 to 5. If you do not like the update, you can select "Skip" below.TheCheckForUpdates (notRecommended) ", click" Next "to continue:

 

Figure 1-5

4. Select the appropriate installation type according to the installation type description file on the right, as shown in figure 1-6. Modify the installation path to avoid re-installing MySQL after the system is reinstalled:

Figure 1-6

5. According to the installation type you selected, you will need to install some framework), click "Execute" to install the required framework, 1-7:

Figure 1-7

6. During framework installation, 1-8:

Figure 1-8

7. After the framework is successfully installed, 1-9:

Figure 1-9

8. After the required frameworks are successfully installed, click "Next" from 1 to 10 ":

Figure 1-10

9. Start installation. 1-11. Click "Execute". During installation, page 1-12 is displayed:

Figure 1-11

Figure 1-12

10. Confirm the configuration information. Click "Next" from 1 to 13 ":

Figure 1-13

11. server configuration selection, DeveloperMachine-the installed MySQL Server is part of the development Machine. Among the three types of selection, the Server occupies the least memory.Machine-the installed MySQL Server is a part of the server Machine and occupies three types of data in the center;DedicatedMySQLServerMachine -- install a dedicated MySQL database server, which occupies all the valid memory of the Machine. If you do not want to modify the default port 3306, click "Next ":

Figure 1-14

12. Set the administrator password, 1-15, and select "AddYou can also create users. It is best not to create users from the security perspective:

Figure 1-15

13. On the page 1-16, you can set the name of the system server, whether the MySQL database server is automatically started at the same time, the default options are available, and click "Next ":

Figure 1-16

14. confirm that the installation is complete and check "Start ".MySQLWorkbenchAfter"Setup" to test whether the installation is successful. Click "Finish ":

Figure 1-17

Iii. Installation successful

1. Workbench appearsGUI page, 1-18, installed successfully:

Figure 1-18

Edit recommendations]

1. MySQL 5.6.10 vs Percona 5.6.6 TPCCC performance test
2. MariaDB has become a turning point in the fate of MySQL?
3. Rollback in case of a DELETE misoperation in MySQL
4. One-step migration from MySQL to Redis
5. Two ways to solve the problem of master-slave synchronization in mysql