Windows system installation MySQL compressed zip version

1. Download

Open Official Website: https://www.mysql.com

Go to Downloads---MySQL Community Server and select the appropriate version of the system. (The red Circle chooses the win 64-bit zip version):

Can skip registration direct download

2. Installation Configuration

Download complete extract directly to any directory, such as D:\Program files\mysql-5.7.22-winx64

Create a new My.ini file under this directory, and configure it as follows (modify it to its corresponding directory):

[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.22-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\program Files\mysql-5.7.22-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

3. Service installation and operation

Run cmd with administrator privileges
Into the bin of MySQL
Execute initialization command
mysqld--initialize-insecure (root password not set)
Service installation
Mysqld-install

Service Run

net start MySQL

Start successfully,

Windows system installation MySQL compressed zip version