MySQL zip file installation

1. Download

https://dev.mysql.com/downloads/mysql/

2. Unzip, configure environment variables

Mysql_home:d:\mysqlpath back add:%mysql_home%\bin 3.Add File My.ini file, Data folder

[mysql]# set MySQL client default character set Default-character-set=utf8[mysqld] #设置3306端口port = 3306# Set the installation directory for MySQL basedir=d:\mysql5.7# Set the data storage directory for the MySQL database datadir=d:\mysql5.7\data# the 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

4. under the Bin folder of the installation directory , run cmd as an administrator, such as D:mysql\bin, then initialize the database and remember the assigned password

Mysqld--initialize--user=mysql--console

5. Installation Start-up

Mysqld--install MySQL

net start MySQL

Note: If the system is missing the Msvcp120.dll file at startup, download the C + + 2013 Library

Address: https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=40784

6. Change the password

SET PASSWORD = PASSWORD (' your password ');

MySQL zip file installation