Detailed illustration of installation and configuration of MySQL 5.6 under Windows

First, pre-installation preparation

1, download the installation package, can go to MySQL official website http://www.mysql.com/download, 1-1:

Figure 1-1

Download the installation file as shown in 1-2:

Figure 1-2

Second, installation

1, double-click the downloaded installation file, this blog post installs the MySQL version is 5.6.10.1, the page appears 1-3:

Figure 1-3

2. Click "Install MySQL Products" and go to page 1-4:

Figure 1-4

3, tick "I Accept
The license
Terms ", click" Next ", appear 1-5 to find the latest product update page, do not like to update, you can choose the below" Skip
The check for updates (not
Recommended) ", click on" Next "to continue:

Figure 1-5

4. depending on the installation type description file on the right side, choose the appropriate installation type, 1-6, note modify the installation path, in case of reloading the system, you need to install MySQL again:

Figure 1-6

5, depending on the type of installation you choose, you will need to install some framework (framework), click "Execute" to install the required framework, 1-7:

Figure 1-7

6, the installation of the framework in the process of the page, 1-8:

Figure 1-8

7, the framework after the successful installation of the prompt, 1-9:

Figure1-9

8, the required framework is installed successfully, 1-10, click "Next":

Figure 1-10

9, start the installation, 1-11, click on "Execute", the installation process of the interface 1-12:

Figure 1-11

Figure 1-12

10, the configuration information to determine, 1-13, click "Next":

Figure 1-13

11, server Configuration type choice, Developer
machine--installed MySQL server as part of the development machine, in three types of selection, the use of the least memory, server machine--installed MySQL server as part of the server machine, occupy within the presence of three types in the center; dedicated MySQL Server
machine--installs the dedicated MySQL database server, which occupies all the valid memory of the machine. Do not modify, the default port 3306 and so on can not be modified, click "Next":

Figure 1-14

12, set the administrator password, 1-15, select " Add User", you can create users, from a security perspective, it is best not to create users:

Figure 1-15

13, in the 1-16 interface, you can set the system server name, whether the system starts and automatically automatically MySQL database server, the default options available, click "Next":

Figure 1-16

14, confirm the installation is complete, tick " Start MySQL
Workbench after setup, you can test for a successful installation, click "Finish":

Figure 1-17

Third, the installation is successful

1, appeared Workbench GUI page, 1-18, installation success:

Figure 1-18

Original link: http://blog.sina.com.cn/s/blog_7cecec9501017cmk.html

Detailed illustration of installation and configuration of MySQL 5.6 under Windows