Win2008 R2 WEB environment configuration MYSQL 5.6.22 installation version installation and configuration method_MySQL

Version selection

Because there are more and more versions of MySql, and small and medium-sized website owners may not have enough money to buy the commercial version, so they generally choose the free version, and the functions are sufficient.

If you have money, download the enterprise version if you want, haha.

Currently the most used version is mysql installer community, which is called the community version and is also a free version.

Download MySql

1. Go to the mysql official website to download, and you can choose the corresponding version to download. Recommended

2. Search and download through the search engine, and find a trusted resource site to download the corresponding version.

The latest community version I chose here is mysql installer community-5.6.22.0. The following tutorials are based on this version.

Installation starts

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

Installation protocol interface

Check "I accept the lincese terms" and click "Next",

The meaning of each setting in the installation type interface:

Developer Default: Installed by default.

Server only: The public server is the database server.

Client only: The public is the client.

Full: completely safe type.

Custom: Custom installation

Here we select "Custom" to customize the installation,

Select products and features interface,

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

Select the "MySql Servers" option in "Category", and for "Architecture" you can select "Any" or one of them. I chose "64-bit" here,

I only installed the most important MySql Server 5.6.22 service, and there are no other options.

You can also directly install all functions by default.

"Install Directory": refers to the installation path,

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

It is recommended to choose non-system disk.

Click “Execute” to install

Installation successful. Click "Next" to proceed to the next step,

Click "Next" to enter the configuration interface,

Configuration type, I chose "Server Machine" here, which is used as a dedicated database server,

Just use the default 3306 for the TCP/IP port.

Set a default password with a minimum length of 4 characters and the default administrator is root.

You can also add users specifically and assign different permissions according to different roles.

Installed as a system service and started when the system starts.

Start configuration,

Configuration completed.

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

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

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

Enter the administrator password we set during installation,

If you see the above interface, it means the installation has been successful. The connection id, version number and copyright of mysql are displayed on the surface.

Okay, now you can officially start your MySql journey.

Original works are allowed to be reprinted. When reprinting, please be sure to indicate the original source of the article, author information and this statement in the form of a hyperlink. Otherwise legal liability will be pursued.

The script editor added:

Of course, after installing the mysql database, it is best to let mysql run as a normal user with elevated rights.

For configuration optimization of mysql 5.6, please refer to this article: http://www.bitsCN.com/article/84357.htm