Mysql-5.7.15-winx64 installation under the Windows 10 platform

White hair fishing firewood on the river, accustomed to see twists.

A pot of turbid wine to meet, ancient and modern how many things, all pay a joke. --" Riverside Fairy"

First, download

1. Download MySQL version on the official website: https://downloads.mysql.com/archives/community/

2. Download complete decompression to the specified path:

Second, configure MySQL

Under the mysql-5.7.15-winx64 directory, copy My-default.ini is named My.ini.

Configuring the My.ini File

[MySQL]# Set the MySQL client default character setdefault-character-Set=UTF8[mysqld]# Set 3306 ports Port= 3306Skip-Grant-tables# Set the installation directory for MySQL Basedir=D:\Program Files (x86) \mysql-5.7. the-winx64# Set the data storage directory for the MySQL database DataDir=D:\Program Files (x86) \mysql-5.7. the-winx64\data# Maximum number of connections allowed Max_connections= $# The character set used by the service side defaults to the 8-bit encoded latin1 character Setcharacter-Set-Server=utf8# default storage engine to use when creating a new tabledefault-Storage-Engine=INNODB

Third, install the MySQL service

1. Run cmd as Administrator and specify to the MySQL installation location under Bin file, run mysqld install installation

2. Use mysqld--initialize to initialize the data directory, and in the installation directory

Iv. Change of password

　　1. Start the MySQL service;

2. Go to MySQL database and change password

Mysql>  UseMySQL;DatabaseChangedmysql> UpdateMysql.User SetAuthentication_string=Password'zxm5312')where User='Root'; Query OK,1Row affected,1Warning (0.00sec) Rows matched:1Changed:1Warnings:1MySQL>FlushPrivileges; Query OK,0Rows Affected (0.00Sec

Mysql> set Password=password (' zxm5312 ');
Query OK, 0 rows affected, 1 Warning (0.00 sec)

3. Exit the MySQL service, comment out the config file in Skip-grant-tables, and then restart the MySQL service to log in to the MySQL database.

[MySQL]# Set the MySQL client default character setdefault-character-Set=UTF8[mysqld]# Set 3306 ports Port= 3306# Skip-Grant-Tables[comment out here]# Set up the MySQL installation directory Basedir=D:\Program Files (x86) \mysql-5.7. the-winx64# Set the data storage directory for the MySQL database DataDir=D:\Program Files (x86) \mysql-5.7. the-winx64\data# Maximum number of connections allowed Max_connections= $# The character set used by the service side defaults to the 8-bit encoded latin1 character Setcharacter-Set-Server=Utf8

Mysql-5.7.15-winx64 installation under the Windows 10 platform