win2008 R2 Web Environment configuration Mysql 5.6.22 Installation configuration method _mysql

Version selection

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

The rich wayward download Enterprise version, haha.

The most widely used version is the MySQL installer community, a Community edition and a free version.

Download MySQL

1, to MySQL official website download, you can choose the appropriate version of the download. Recommended

2, search for search and download, find a trusted resource station download the corresponding version.

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

Installation start

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

Installation Protocol Interface

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

The installation type interface sets various meanings:

Developer Default: Installation defaults.

Server only: Public as the database server.

Client only: public as clients.

Full: Fully secure type.

Custom: Customizing the Installation

Here we select "Custom" to customize the installation,

Select the product and feature interface,

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

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

I only have the main MySQL Server 5.6.22 service installed, and none of the other options are available.

You can also install all features directly by default.

"Install Directory": Refers to the installation path,

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

Recommendations are selected under a non-system disk.

Dot kat "Execute" for installation

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

Click "Next" to enter the configuration interface,

Configuration type, I choose "Server Machine" here, as a dedicated database server,

TCP/IP ports use the default 3306.

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 based on different roles.

Installed as system service, started with system boot.

Start configuration,

Configuration complete.

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

MySQL has installed a connection tool by default, named "MySQL 5.6 Command line Client", which allows you to connect to the database.

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

Enter the admin password that we set up when we installed the

If you see the above interface, it indicates that it has been installed successfully. The connection ID, version number, and copyright of MySQL are displayed on the face.

Well, the following is the official opening of the MySQL tour.

Original works, allow reprint, reprint, please be sure to hyperlink form to indicate the original source of the article, author information and this statement. Otherwise, legal liability will be held.

Script Widget Supplements:

Of course, after installing MySQL database, it is best to let MySQL ordinary users run, put right.

MySQL 5.6 configuration optimization can refer to this article: http://www.jb51.net/article/84357.htm