"MYSQL" mysql-5.7.20-winx64 installation configuration

Order:

MySQL installation configuration issues on Windows systems.

0x01

Go to MySQL's official website to download the MySQL free installation file you want to build. https://dev.mysql.com/downloads/mysql/

0x02

Unzip the downloaded file. The Data folder and the My.ini file are not found in the root directory.

0x03

Initialize MySQL, under DOS CD to the MySQL Bin folder. After running the return root directory will be sent under the data folder has been generated

　　

Mysqld--initialize-insecure--user=mysql

　　

0x04

The downloaded 5.7.20 version already does not include the My.ini file and needs to be created and filled out manually.

　　

[client] Port=3306default-character-set=UTF8[mysqld]  # Set the installation directory for your own MySQL basedir=d:\mysql-5.7.20-winx64# Set the data directory for MySQL datadir=d:\mysql-5.7.20-winx64 \dataport=3306character_set_server=utf8sql_mode=no_engine_substitution,no_ auto_create_user# Open Query Cache explicit_defaults_for_timestamp=trueskip-grant-tables

0x05

The following is the installation of MySQL, under DOS commands CD to the root directory of MySQL. such as prompt service successfully installed. The identity installation was successful.

　　

Mysqld-install

　　

0x06

Input net start MySQL start service

　　

　　

"MYSQL" mysql-5.7.20-winx64 installation configuration