Edited by: Vocabulary
The following details of the 5.6 version of MySQL download, installation and configuration process.
Figure 1.1 MySQL5.6
Currently, MySQL offers 2 different versions for different users:
Ømysql Community Server: Community Edition, this version is completely free, but the official does not provide technical support.
Ømysql Enterprise Server: Enterprise Edition, which delivers cost-effective data warehousing applications, supports acid handling, and delivers complete commit, rollback, crash recovery, and row-level locking capabilities. However, this version should be paid for, and the Government will provide technical support such as telephone and documentation.
The latest version of MySQL is MySQL 5.6, which can be downloaded from the official website http://dev.mysql.com/downloads/ . The MySQL official web site, shown in Figure 1.2 below, clicks the "Download" hyperlink on the picture or clicks on the left marker , and then follows the prompts to download the MySQL software to the local computer. Note that the database version we selected here is "Windows (x86, 32-bit), MSI Installer," as shown in Figure 1.3 below.
Figure 1.2 MySQL official website
Figure 1.3 Choosing the MySQL version
Ø When you click Download , the following page will pop up:
Note : Download mysql requires registered:< users can register or not register , if you do not want to register click on the lower left corner mark- click on
Pop-up as shown in the download prompts-> Click Save file to start downloading.
After the download is complete, locate the file that is downloaded to the local ømysql, and then double-click to install it as shown in the following steps:
Step 1: Double-click the MySQL installer (mysql-installer-community-5.6.10.1) to pop up as shown in Figure 1.4 below:
Figure 1.4 MySQL Welcome interface
Step 2: Click the "Install MySQL products" text in Figure 1.4 to eject the User License agreement window,
As shown in Figure 1.5 below:
Figure 1.5 User License Agreement window
Step 3: Select the previous selection box for "I accept the License Terms" and click the "Next" button to enter
Find the latest version of the interface, the effect is as shown in Figure 1.6:
Figure 1.6 Finding the latest version of the window
Step 4: Click the Execute button to enter the setup type Setup interface, as shown in Figure 1.7 below.
Figure 1.7 Setup Type Setup window
Table 1-1 Installation Type interface meaning of each set item
Options |
Meaning |
Developer Default |
Default installation Type |
Server only |
As Server only |
Client only |
As a client only |
Full |
Full Installation Type |
Custom |
Custom Installation Type |
Installation Path |
Application Installation Path |
Data Path |
The path to the database data file |
Step 5: Select the "Custom" option in Figure 1.7 to Modify the installation path or keep the default value , and then click the Next button,
The pop-up feature selection interface is shown in figure 1.8 below.
Figure 1.8 Feature Selection window
Step 6: Click the "Next" button to eject the installation condition Check screen, as shown in Figure 1.9 below.
Figure 1.9 Installation Condition Check interface
Step 7: Click the "Next" button to install the interface, as shown in Figure 1.10 below.
Figure 1.10 Program Installation Interface
Step 8: Click the Execute button to start the Setup program. Settings that are made during the Setup Wizard after the installation is complete are completed during installation
After it takes effect, the window shown in Figure 1.11 below
Figure 1.11 Program installation Successful interface
Step 9: Click the "Next" button to enter the server Configuration page, as shown in Figure 1.12 below.
Figure 1.12 Server Configuration page
Step 10: Click the Next button and the effect is shown in Figure 1.13 below.
Figure 1.13 Configuration Page One
The "Config type" Drop-down list item under "Server Configuration type" in Figure 1.13 is used to configure the type in front of the server. Choosing which server will affect the MySQL Configuration Wizard (Configuration Wizard) for memory, hard disk, and process or usage decisions, you can choose from the 3 types of servers shown below:
Ødeveloper Machine (Development machine): This option represents a typical personal desktop workstation. Assume that there are multiple desktop applications running on the machine. Configure the MySQL server to use minimal system resources.
Øserver Machine (server): This option represents the server that the MySQL server can run with other applications, such as FTP, email, and Web servers. The MySQL server is configured to use the appropriate proportional system resources.
ødedicated MySQL server Machine (dedicated MySQL servers): This option represents a server running only the MySQL service. Assume that the run does not run another application. The MySQL server is configured to use all available system resources.
As a beginner, choosing the "Developer Machine" (developer Machine) is enough to take up a system that doesn't have a lot of resources. In the checkbox to the left of the Enable TCP/IP networking, you can enable or disable the TCP/IP network and configure the port number that is used to connect to the MySQL server, by default, TCP/IP networking, and the default port is 3306. To change access to the port used by MySQL, enter the new port number directly in the text entry box, but make sure that the new port number is not occupied.
Step 11: Click the "Next" button, and in the corresponding interface in Figure 1.13, we need to set the Root password, enter the desired password in "MySQL root password" (enter the new password) and the "Repeat Password" (confirm) two edit boxes. You can also add new users by clicking the "Add User" button below. ( Note: The current Root Password: null; If you enter a password in the following installation will be an error )
The following is the successful addition of the user
Figure 1.13 Configuration Page Two
Step 12: Click the "Next" button to set Windows service name< to the default, which is the name of the start database services, remember.
The effect is shown in Figure 1.14 below.
Figure 1.14 Configuration Page Three
Step 13: Click the "Next" button to open the configuration information Display page, as shown in Figure 1.15 below.
Next Click
Figure 1.15 Configuration Information Display page
Step 14: Click the "Next" button to complete the entire installation configuration process for the MySQL database. Then start the Database service command and then
By opening Task Manager , you can see that the MySQL service process Mysqld.exe has been started, as shown in 1.16.
In the Start menu bar-> attachment-> right command prompt-> run as Administrator: net start MySQL56 to start database service command;
net stop MySQL56 to stop the database service command .
Figure 1.16 Task Manager window
o so far, we have successfully installed MySQL on Windows. Next you can start the MySQL service and login to the database to do their own operation.