mysql-5.7.19 winx64 Release Installation configuration tutorial

MySQL Compressed package file

1. Go to mysql website download https://dev.mysql.com/downloads/mysql/download installation package

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/9D/48/wKioL1l9dPmxY9YMAAF3t7GrDbc744.png "style=" float : none; "title=" QQ picture 20170730133311.png "alt=" Wkiol1l9dpmxy9ymaaf3t7grdbc744.png "/>

corresponding system and version number, download WINDOWS64 bit zip package here

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/9D/48/wKiom1l9dPeTlctEAAFCUvmL1aQ617.png "title=" Qq20170730133347.png "style=" Float:none; "alt=" Wkiom1l9dpetlcteaafcuvml1aq617.png "/>

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/48/wKiom1l9dZbQvLjKAAAI3Xbj8UI372.png "title=" QQ picture 20170730134757.png "alt=" Wkiom1l9dzbqvljkaaai3xbj8ui372.png "/>

Compressed Package Decompression Installation

1. Unzip the ZIP package to the specified directory can be installed in any system disk, I am accustomed to install under the D disk, the directory structure is as follows D:\Program files\mysql-5.7.19-winx64 so far just download the compressed package and extract to the corresponding directory, The MySQL service is not installed yet.

Configuring the My.ini file

In D:\Program files\ Mysql-5.7.19-winx64 (Note that this directory and your own directory, I download the 5.7 version, if you download the 5.5 version, this directory is not the same) directory to create a new configuration file, the file named My.ini, and then copy the following configuration code to the My.ini (the path in the code To change to their own file storage path).

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/9D/48/wKiom1l9d3fCZX9gAABhC7eDyU8879.png "title=" QQ picture 20170730140556.png "alt=" Wkiom1l9d3fczx9gaabhc7edyu8879.png "/>

The contents of the My.ini file are as follows:

[MySQL]

# Set the MySQL client default character set

Default-character-set=utf8

[Mysqld]

#设置3306端口

Port = 3306

# set up the MySQL installation directory

Basedir=d:\program files\mysql-5.7.19-winx64

# Set up a storage directory for MySQL database data

Datadir=d:\program Files\mysql-5.7.19-winx64\data

# Maximum number of connections allowed

max_connections=200

# The character set used by the service side defaults to the 8-bit encoded latin1 character set

Character-set-server=utf8

# The default storage engine that will be used when creating a new table

Default-storage-engine=innodb

To install the MySQL service:

Run as administrator, locate this cmd.exe in the start directory, and right-click Run as Administrator. Note Be sure to run as administrator, or the installation will not succeed. After you open the CMD window as an administrator, switch the directory to the bin directory where you unzipped the files, and then enter mysqld install to run.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/9D/48/wKioL1l9ePyQ6KlkAAA-fCNsCSE249.png "title=" QQ picture 20170730141225.png "alt=" Wkiol1l9epyq6klkaaa-fcnscse249.png "/>

Successful installation prompts you

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/9D/48/wKioL1l9eVrxIimxAAAHDQlx9EI263.png "title=" QQ picture 20170730141357.png "alt=" Wkiol1l9evrxiimxaaahdqlx9ei263.png "/>

MySQL after installation is still a very important step, need to run mysql_install_db initialize MySQL this system library, in order to start normally.

A data folder will be added to the Mysql-5.7.19-winx64 folder after the run is complete, and there will be a lot of information initialized in it. Remember that the data folder must not be created manually.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/9D/49/wKiom1l9gsGCewn5AAAWuBRUQU8277.png "title=" Aaaa.png "alt=" Wkiom1l9gsgcewn5aaawubruqu8277.png "/>

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/9D/48/wKiom1l9eemC7bGRAACLo1RIZPo148.png "title=" QQ picture 20170730141619.png "alt=" Wkiom1l9eemc7bgraaclo1rizpo148.png "/>

Start the MySQL service.

① Control Panel-"management tool-" service-"mysql-" started.

At this point, you can use the MySQL service. After installation, the startup process, if the 1066 error, is due to the My.ini configuration problem, focus on the My.ini inside the path has been modified to their own path.

When you enter the command mysql-uroot-p connect to the database, you will be prompted to enter a password, root password default is empty, directly press ENTER on the line

Or use the Administrative Tools Navicat premium to connect to the local library,

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/9D/48/wKioL1l9e1LjxfmcAABAnmTGRWo282.png "title=" QQ picture 20170730142221.png "alt=" Wkiol1l9e1ljxfmcaabanmtgrwo282.png "/>

at this point, if a 10038 error occurs, then continue with the following actions

10038 Error: Remote 3306 port is not open.

The following is a remote 3306 port open operation.

First connect to the server remotely, click Start-Administrative Tools-Windows Firewall with Advanced Security

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/9D/48/wKiom1l9fEqCr4TRAAEm1yBph5k001.png "title=" Qq20170730142607.png "alt=" Wkiom1l9feqcr4traaem1ybph5k001.png "/>

In the open window, select "Inbound Rules" on the left and click "New rule" on the right to create a new inbound rule.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/9D/48/wKioL1l9fRbSi8isAAFu7-4KjUY332.png "title=" QQ picture 20170730142956.png "alt=" Wkiol1l9frbsi8isaafu7-4kjuy332.png "/>

In rule type, select port, and then next.

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/48/wKioL1l9fibC0HtiAABA4oYkSy4154.png "style=" float : none; "title=" 1.png "alt=" Wkiol1l9fibc0htiaaba4oyksy4154.png "/>

Select "Specific local Port", enter 3306, and then next.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/9D/48/wKiom1l9fifDtSDRAABBMivInO0114.png "style=" float : none; "title=" 2.png "alt=" Wkiom1l9fifdtsdraabbmivino0114.png "/>

Check "Allow connections" and then next.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/9D/48/wKiom1l9flvTJG7tAAA8UPiGcPY962.png "title=" 4.png "alt=" Wkiom1l9flvtjg7taaa8upigcpy962.png "/>

This step is selected by default on the line, and then next.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/9D/48/wKioL1l9fiewNh_gAABJaFlOsqM790.png "style=" float : none; "title=" 3.png "alt=" Wkiol1l9fiewnh_gaabjaflosqm790.png "/>

Finally enter the new inbound rule name, fill it out, you can understand.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/9D/48/wKiom1l9fijxq3UYAAAuTYnWnfQ143.png "style=" float : none; "title=" 5.png "alt=" Wkiom1l9fijxq3uyaaautynwnfq143.png "/>

When you are finished, you can see the new inbound rules in the list of inbound rules.

6 this.width=650, "src=" Https://s1.51cto.com/wyfs02/M02/9D/48/wKioL1l9fryzcKLfAAFgab9MKgE189.png "title=" 6.png " alt= "Wkiol1l9fryzcklfaafgab9mkge189.png"/>

Now, once again, when you connect to the MySQL remote database locally, you find that you have access to it properly. If not, restart the service to reconnect.

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/48/wKioL1l9f3nDiXUgAACEAU4lX5w924.png "title=" 22. PNG "alt=" Wkiol1l9f3ndixugaaceau4lx5w924.png "/>

This article is from the "12773255" blog, please be sure to keep this source http://12783255.blog.51cto.com/12773255/1952089

mysql-5.7.19 winx64 Release Installation configuration tutorial