The following describes the download, installation, and configuration process of MySQL version 5.6 in detail.
Figure 1.1 MySQL 5.6
Currently, MySQL offers 2 different versions for different users:
Ø MySQL Community Server: Community Edition, this version is completely free, but the official technical support is not provided.
Ø MySQL Enterprise Server: Enterprise Edition, which can provide cost-effective data warehouse applications for enterprises, support ACID thing processing, and provide complete commit, rollback, crash recovery, and row-level locking functions. However, this version requires payment to use, and the official provides technical support such as phone calls and documents.
The latest MySQL version is MySQL 5.6, which can be found on the official websitehttp://dev.mysql.com/downloads/Download the software. Click on the image on the MySQL official website shown in Figure 1.2 below"Download" hyperlinkorClick on the mark on the left, and then follow the prompts step by step to download the MySQL software to your local computer. Note that the database version we chose here is "Windows (x86, 32-bit), MSI Installer", as shown in Figure 1.3 below.
Figure 1.2 MySQL official website
Figure 1.3 Select the MySQL version
Ø When clickeddownloadThe following page will pop up:
NoteDownload MySql Requirements Registration: <Users can register or not register>, if you don't want to registerClick on the mark in the lower left corner —Click on it
The download prompt will pop up as shown in the picture - > click to save the file to start downloading.
Once the MySQL download is complete, locate the file downloaded locally and follow the steps shown below to double-click to install it:
Step 1: Double-click on the MySQL installer (mysql-installer-community-5.6.10.1) and it will 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, and the User License Agreement window will pop up.
As shown in Figure 1.5 below:
Figure 1.5 User license agreement window
Step 3: Select the selection box in front of "I accept the license terms", and then click the [Next] button to enter the search
Find the latest version of the interface, the effect is shown in Figure 1.6 below:
Figure 1.6 Finding the latest version window
Step 4: Click the [Execute] button to enter the installation type setting interface, as shown in Figure 1.7 below.
Figure 1.7 Installation type settings window
Table 1-1 Meaning of each setting item on the installation type screen
options
| meaning
| Developer Default
| Default installation type
| Server only
| As a server only
| Client only
| As a client only
| Full
| Fully mounted type
| Custom
| Customize the 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,You can modify the installation pathorKeep the default values, and then click the [Next] button,
The pop-up function selection screen is shown in Figure 1.8 below.
Figure 1.8 Function selection window
Step 6: Click the Next button to pop up the installation condition check interface, as shown in Figure 1.9 below.
Figure 1.9 Installation condition check screen
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 installation program. When the installation is complete, the settings made during the installation wizard will be completed in the installation
It will take effect after that, as shown in Figure 1.11 below
Figure 1.11 Program installation success 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, the effect is shown in Figure 1.13 below.
Figure 1.13 Configuration page 1
The "Config Type" drop-down item under "Server Configuration Type" in Figure 1.13 is used to configure the server-facing type. The server you choose will influence the MySQL Configuration Wizard's decisions about memory, hard disks, and processes or usage, and you can choose from the following 3 server types:
Ø Developer Machine: This option represents a typical personal desktop workstation. Suppose there are multiple desktop applications running on the machine. Configure the MySQL server to use minimal system resources.
Ø Server Machine: This option represents a server, and MySQL servers can run with other applications, such as FTP, email, and web servers. The MySQL server is configured to use the appropriate proportion of system resources.
Dedicated MySQL Server Machine: This option represents a server that only runs MySQL services. Assume that no other applications are running. The MySQL server is configured to use all available system resources.
As a beginner, it is enough to choose "Developer Machine" so that it does not take up a lot of resources on the system. In the checkbox on the left side of Enable TCP/IP Networking, you can enable or disable TCP/IP networking, and configure the port number used to connect to the MySQL server, and enable TCP/IP networking by default, with the default port being 3306. To change the port used to access MySQL, simply enter the new port number in the text input box, but make sure that the new port number is not occupied.
Step 11: Click the [Next] button, in the interface corresponding to Figure 1.13, we need to set the root user's password, and enter the desired password in the two editing boxes of "MySQL Root password" (enter a new password) and "Repeat Password" (confirm). You can also click the Add User button below to add a new user. (Note: Current Root Password: is empty; If you enter the password and install it later, an error will be reported)
Here are the successful users added
Figure 1.13 Configuration page 2
Step 12: Click the Next button,Set the Windows Service Name<可默认>, which is called the startup database service name, to remember.
The effect is shown in Figure 1.14 below.
Figure 1.14 Configuration page 3
Step 13: Click the Next button to open the configuration information display page, as shown in Figure 1.15 below.
Nextclick
Figure 1.15 Configuration information display page
Step 14: Click the [Next] button to complete the entire installation and configuration process of MySQL database. After thatStart the database service commandAgain
HitOpen Task Manager, you can see that the MySQL service process mysqld.exe has started, as shown in 1.16.
In the Start menu bar - >Annex - >Right-click Command Prompt - > run as administrator: net start MySQL56 forStart the database service command;
net stop MySQL56 forStop database service command。
Figure 1.16 Task Manager window
Ø So far, we have successfully installed MySQL on Windows. Next, you can start the MySQL service and log in to the database to perform your own operations.
|
Posted on 2/3/2015 2:00:25 PM
|
|
|
|
