The installation and configuration of MySQL5.6 in windows are provided with screenshots and detailed descriptions.

Edited by: Vocabulary

The following describes how to download, install, and configure MySQL 5.6.

 

Figure 1.1 MySQL5.6

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.6, which can be found on the official website.Http://dev.mysql.com/downloads/Download the software. On the MySQL official website, as shown in 1.2, click"Download" hyperlinkOrClick mark on the leftThen, follow the prompts to download the MySQL software to the 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

When you clickDownloadThe following page is displayed:

Note: Required MySql registration for download: <Users can register or not register> If you do not want to registerClick "mark" in the lower left corner-Click

In the displayed dialog box, click Save file to start downloading.

After MySQL is downloaded, find the file to be downloaded to the local device and double-click it to install it as follows:

Step 1: double-click the MySQL Installer (mysql-installer-community-5.6.10.1), as shown in 1.4:

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,

See 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 "Next" to check

Find the latest version of the interface, as shown in Figure 1.6:

 

Figure 1.6 find the latest version window

Step 4: Click Execute to go to the installation type setting page, as shown in Figure 1.7.

Figure 1.7 installation type setting window

Table 1-1 Definitions of configuration items on the installation type interface

Option	Description
Developer Default	Default installation type
Server only	Server only
Client only	Only as a client
Full	Full installation type
Custom	Custom installation type
Installation Path	Application installation path
Data Path	Path of the database data file

Step 5: Select "Custom" in Figure 1.7,You can modify the installation path.OrRetain Default ValueAnd then click Next,

The function selection page is displayed, as shown in Figure 1.8.

Figure 1.8 function Selection window

Step 6: Click Next to bring up the installation condition check page, as shown in 1.9.

Figure 1.9 installation condition check page

Step 7: Click Next to install the SDK, as shown in Figure 1.10.

Figure 1.10 installation page

Step 8: Click Execute to start installation. After the installation is complete, the settings made during the installation wizard are complete.

Take effect later, as shown in window 1.11

Figure 1.11 successful program installation page

Step 9: Click Next To go to the server configuration page, as shown in Figure 1.12.

Figure 1.12 server configuration page

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

Figure 1.13 configuration page 1

The "Config Type" drop-down list under "Server Configuration Type" in Figure 1.13 is used to configure the Server Type. Which server will affect the memory, hard disk, and process or usage decisions of the MySQL Configuration Wizard? You can select the following three server types:

Developer Machine: This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server to use the least amount of system resources.

Server Machine (Server): This option indicates the Server. The MySQL Server can run with other applications, such as FTP, email, and web servers. Configure the MySQL server to use the appropriate proportion of system resources.

Ø Dedicated MySQL Server Machine (Dedicated MySQL Server): This option indicates a Server that only runs the MySQL service. It is assumed that no other application is running. The MySQL server is configured to use all available system resources.

As a beginner, it is enough to select "Developer Machine" (Developer Machine), which will not occupy a lot of system resources. Enable or disable the TCP/IP network in the check box on the left of Enable TCP/IP Networking and configure the port number used to connect to the MySQL server. By default, the TCP/IP network is enabled, the default port is 3306. To change the port used to access MySQL, enter the new port number in the text input box, but ensure that the new port number is not occupied.

Step 11: click Next. On the page corresponding to Figure 1.13, set the root user password in "MySQL Root password" (enter a new password) and "Repeat Password" (OK. You can also click Add User to Add a new User. (Note: Current Root Password: NULL. If the Password is entered, an error will be reported for subsequent installation.)

The following are successfully added users:

Figure 1.13 configuration page 2

Step 12: click Next,Set Windows Service Name <default>, which is the Name of the Database Service to start. Remember this Name.

The effect is shown in 1.14.

Figure 1.14 configuration page 3

Step 13: Click Next to open the configuration information display page, as shown in 1.15.

NextClick

Figure 1.15 configuration information display page

Step 14: Click Next to complete the installation and configuration of the MySQL database. AfterStart Database Service commandsAgain

DozenStart Task Manager, You can see that mysqld.exe has been started, as shown in 1.16.

In the Start Menu Bar, choose>Attachment->Right-click the command prompt-> Run as administrator: net start MySQL56 isStart Database Service commands;

Net stop MySQL56 isStop Database Service commands.

Figure 1.16 Task Manager window

ØSo far, we have successfully installed MySQL on Windows. Next, you can start the MySQL service and log on to the database to perform your own operations.