Windows MySQL5.6 version installation and configuration process with screenshots and detailed instructions _mysql

Source: Internet
Author: User
Tags mysql download mysql version save file

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.