WINDWS Server R2 Web environment configuration MySQL 5.6.22 installation configuration

Version selection

Because MySQL version more and more, and as small and medium-sized website may not have enough economy to buy commercial version, so generally choose free version, and the function is enough to use.

Rich willful download Enterprise Edition, haha.

Currently the most used version is MySQL installer community, which is called Community Edition and is also free version.

download MySQL

1, go to the MySQL official website to download, you can choose the corresponding version download. Recommended

2. Search for download by searching for the trusted resource station to download the corresponding version.

I choose the latest community edition here, MySQL installer community-5.6.22.0, the following tutorials are all based on this version.

Installation start

Double-click the downloaded MySQL installer community-5.6.22.0 icon,

Install the Protocol interface

Tick "I Accept the Lincese terms", click "Next",

The installation type interface each setting each meaning :

Developer Default: Defaults to install.

Server only: Public as database server.

Client only: public as the clients.

Full: Complete security type.

Custom: Customized Installation

Here we choose "Custom", from the definition of the installation,

Select Product and Feature interface,

You can click the "Filter" input box, pop up the product selection box,

Select "MySql Servers" option in "Category", "Architecture" You can choose "any" or one of them, I choose "64-bit" here,

I only installed the primary MySQL Server 5.6.22 service, and none of the others had a choice.

You can also install all features directly by default.

"Install Directory": refers to the installation path,

"Data Directory": Refers to the database file path,

The recommendations are selected under non-system disks.

Click "Execute" to install

The installation was successful. Click "Next" to enter the next step,

Click "Next" to enter the configuration interface,

Configuration type, I chose "Server machine" here, as a dedicated database server,

The TCP/IP port is 3306 by default.

Set a default password, with a minimum length of 4, and the default administrator as root.

You can also add users specifically, assigning different permissions depending on the role.

Install as system service and start with system boot.

Start configuration,

Configuration is complete.

At this point, the installation of Mysql has been completed. Let's try it first, can not connect the database.

MySQL has installed a connection tool by default, called "MySQL 5.6 Command Line Client", which can be used to connect to the database.

Open the Start menu and open the MySQL 5.6 Command line Client,

Enter the administrator password that was set when we installed it.

If you see the interface as above, it indicates that the installation was successful. The connection ID, version number, and copyright of MySQL are displayed on the surface.

Well, the following will officially open the MySQL tour.

original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be investigated. HTTP://BLOG.POSTCHA.COM/READ/10

WINDWS Server R2 Web environment configuration MySQL 5.6.22 installation configuration