Installation tutorial for MySql5.6 in Windows _ MySQL

Installation tutorial for MySql5.6 in Windows

I,Installation prelude

Introduction

MySQL is a relational database management system developed by MySQL AB in Sweden and currently belongs to Oracle. MySQL is an associated database management system that stores data in different tables rather than in a large warehouse. this increases the speed and flexibility. The SQL language of MySQL is the most commonly used standard language for accessing databases. MySQL adopts the dual authorization policy (this term "authorization policy"). It is divided into community edition and commercial edition. because of its small size, fast speed, and low total cost of ownership, especially open source code, MySQL is generally used as the website database for the development of small and medium-sized websites. Due to its superior performance, PHP and Apache can form a good development environment.

Installation environment

Support for. net framework 4.0 or later is required!

II. download and install MySQL

Since the MySQL version was upgraded to MySQL 5.6, the installation and configuration process has greatly changed from the original version. The following describes the download, installation, and configuration process of MySQL 5.6.

. 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.

1) MySQLEnterprise Server: Enterprise Edition, which provides cost-effective data warehouse applications for enterprises, supports ACID transaction processing, and provides 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. Click the "MySQLInstaller 1.2" hyperlink in the lower right corner of the MySQL website, as shown in 5.6, and follow the prompts to download the link. In this example, the downloaded database version is Windows (x86, 32-bit) and MSI Installer, as shown in Figure 1.3.

. 2 official MySQL website

. 3 select MySQL version

After the MySQL download is complete, find the file downloaded to the local device and follow the steps below to install it by double-clicking:

Step 1: Double-click the MySQL installer (mysql-installer-community-5.6.10.1) and a welcome window, as shown in 1.4, will pop up.

. 4 welcome page for MySQL

Step 2: Click the "Install MySQL Products" text in. 4. the user license agreement window is displayed, as shown in figure 1.5.

. 5 user license agreement window

Step 3: Select the "I accept the license terms" option box and click "Next" to go to the latest version page, as shown in Figure 1.6:

. 6. find the latest version.

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

. 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 the "Custom" option in. 7, retain the default values for the remaining items, and click the "Next" button to bring up the function selection interface.

Step 6: deselect the check boxes before "Applications" and "MySQL ORS ors" on the function selection page, and click "Next" to bring up the installation condition check page, as shown in Figure 1.9.

. 9 installation condition check page

Step 7: click Next to go to the installation page, as shown in Figure 1.10.

. 10 program installation interface

Step 8: click Execute to start installation. After the installation is complete, the settings made during the installation wizard take effect after the installation is complete, and a window shown in 1.11 is displayed.

. 11 program installation successful page

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

. 12 server configuration page

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

. 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 MySQLConfiguration Wizard's decision on memory, hard disk, and process or usage? 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 a developer Machine to occupy less system resources.

Enable or disable the TCP/IP network in the check box on the left of Enable TCP/IPNetworking 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 10: click Next, as shown in Figure 1.14.

. 13 configuration page 2

Step 11: In. on the page corresponding to 13, we need to set the root user password. in the "MySQL Root password" and "RepeatPassword" edit boxes, enter the password. You can also click Add User to Add a new User. Click Next, as shown in Figure 1.14.

. 14 configuration page 3

Step 12: click Next to open the configuration information display page, as shown in Figure 1.15.

. 15 configuration information display page

Step 13: click Next to complete the MySQL database installation and configuration process. Open the Task Manager. you can see that mysqld.exe has been started in the mysqlservice process, as shown in Figure 1.16.

. 16 Task Manager window

Step 14: use Navicat Premium (a database management tool) to connect to Mysql.

. 17 use Navicat Premium to connect to Mysql

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.