WIN2008R2 zip format MySQL installation and configuration

One. Baidu mysql5.6 ZIP 64-bit free install version of the download and then extract to the D disk

Two.   You can consider modifying the configuration of My.ini inside Character-set-server=utf8 This sentence is the encoding format setting port=. Port settings

Three. Set the environment variable path. Add D:\mysql-5.6.20-winx64\bin to path.

Four. To install the MySQL service, be sure to enter the D:\mysql-5.6.20-winx64\bin directory to perform the installation mysqld install

Five. Go to Service Manager to start the MySQL service

Six. Enter the database, modify the root account login password 1234, and then create a MySQL remote connection user, set the maximum permissions and login password.

Mysql-u root-p

GRANT all on * * to ' root ' @ ' localhost ' identified by ' 1234 ';

GRANT all on * * to ' sa ' @ '% ' identified by ' 1234 ' with GRANT OPTION;

Seven. Open firewall 3306 Port network->windows Firewall--Advanced settings--Inbound rules and then click New Rule in the upper right corner Select "Port" Next, enter 3306 ports, add the rules,

WIN2008R2 zip format MySQL installation and configuration