Windows Mysql 5.6 Installation and configuration detailed diagram (large plate) _mysql

First, the preparation before installation

1, download the installation package, can be downloaded to the official MySQL website www.mysql.com, as shown in Figure 1-1:

Figure 1-1

The downloaded installation files are shown in Figure 1-2:

Figure 1-2

Second, the installation

1, double-click the download of the installation file, this blog post installed MySQL version of 5.6.10.1, appear as shown in Figure 1-3 page:

Figure 1-3

2, click "Install MySQL Products", into the figure 1-4 page:

Figure 1-4

3, check "I accept the License Terms", click "Next", appear as shown in Figure 1-5 to find the latest product update page, do not like the update, you can choose the bottom of the "Skip the Check for updates" (not Recommended) ", click" Next "to continue:

Figure 1-5

4, according to the right installation type description file to choose their own installation type, as shown in Figure 1-6, pay attention to modify the installation path, in order to prevent 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, as shown in Figure 1-7:

Figure 1-7

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

Figure 1-8

7, the framework after the successful installation of the prompts, as shown in Figure 1-9:

Figure 1-9

8, the required framework after the successful installation, as shown in Figure 1-10, click "Next":

Figure 1-10

9, start installation, as shown in Figure 1-11, click "Execute", the installation process of the interface as shown in Figure 1-12:

Figure 1-11

Figure 1-12

10, configuration information to determine, as shown in Figure 1-13, click "Next":

Figure 1-13

11, Server configuration choice, Developer machine--installed MySQL server as part of the development machine, in three types of choice, the use of the least memory; the MySQL server installed by Server machine--as part of the server machine, There are three types of center in occupancy; dedicated MySQL server machine--installs a dedicated MySQL database server that occupies all of the machine's valid memory. Do not make changes, the default port 3306, etc. can not be modified, click "Next":

Figure 1-14

12, set the administrator password, as shown in Figure 1-15, select "Add user", you can create users, from a security point of view it is best not to create users:

Figure 1-15

13, in the interface of Figure 1-16, you can set the system server name, whether the system started automatically automatically MySQL database server, the default option, click "Next":

Figure 1-16

14, confirm installation completed, check "Start MySQL Workbench after Setup", can be successfully installed for testing, click "Finish":

Figure 1-17

Third, successful installation

1, the appearance of Workbench GUI page, such as Figure 1-18, installation success:

Figure 1-18

Bowen only for learning exchanges, reproduced please indicate the source.