Quickly install MySQL5.7 compressed package on Windows

# MySQL Server Instance Configuration File
# ---------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#Generate by using the MySQL Service Configuration Wizard # Installation Instructions
#Client Parameter Configuration# CLIENT SECTION
# ----------------------------------------------------------------
[client]
#The client connects to the MySQL database server through port number 3306. If you need to change the port number, you can modify it directly.
port=3306
[mysql]
#The default character set of the client is default-character-set=utf8
#Server-side parameter configuration# SERVER SECTION
# -----------------------------------------------------------------
[mysqld]
#Server port number port=3306
#MySQL database server installation directory basedir=E:\mysql\mysql-5.7.18-winx64
#MySQL database data file directory datadir=E:\mysql\mysql-5.7.18-winx64\Data
#MySQL software character set character-set-server=utf8
#MySQL software storage engine default-storage-engine=INNODB
# Set the SQL mode to strict
#SQL mode of MySQL software sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#The maximum number of connections for MySQL software max_connections=100
#MySQL software query cache query_cache_size=0
#The total number of tables that can be opened in the MySQL software #table_cache=256
#The maximum value of temporary tables that can be stored in MySQL software memory is tmp_table_size=11M
#The number of client connection threads that can be retained in the MySQL software thread_cache_size=8
#The maximum temporary file size allowed when MySQL software rebuilds the index myisam_max_sort_file_size=100G
#The maximum cache size allowed when MySQL software rebuilds the index myisam_sort_buffer_size=22M
#The maximum keyword cache size in MySQL software key_buffer_size=10M
#The cache size when MySQL software fully scans the MyISAM table read_buffer_size=64K
#MySQL software can insert the cache size of sorted data read_rnd_buffer_size=256K
#MySQL software user sorting cache size sort_buffer_size=256K
#*** INNODB Specific options ***
#About INNODB storage engine parameter settings#Additional memory pool size (5.7.18 does not have this item)
#innodb_additional_mem_pool_size=2M
#About the timing of committing logs innodb_flush_log_at_trx_commit=1
#The size of the cache area for storing log data innodb_log_buffer_size=1M
#Cache size in the cache pool innodb_buffer_pool_size=52M
#Log file size innodb_log_file_size=26M
#The maximum number of threads allowed innodb_thread_concurrency=9

table_cache=256 //The total number of tables that can be opened in the MySQL software 

innodb_additional_mem_pool_size=2M //Additional memory pool size (5.7.18 does not have this item) 

Add E:\mysql\mysql-5.7.18-winx64\bin under path

mysqld –defaults-file=E:\mysql\mysql-5.7.18-winx64\my.ini –initialize –console
–defaults-file is the path to the my.ini configuration file and should be placed in the first parameter position –console is to display the results in the command prompt window