How Windows Installs Mysql-5.7.17-winx64.zip

1. Go to the official website to download the. zip format file.

2. Unzip to a folder, here I use D:\MYSQL to express

3. Create a new My.ini configuration file under D:\MySql\mysql-5.7.17-winx64

Yellow background color of the place need to replace their own content, remember!!!

################### #配置文件开始 ###################[Client]default-character-Set=UTF8 [mysqld] Port=3306Basedir=" D:\MySql\mysql-5.7.17-winx64/"DataDir=" D:\MySql\mysql-5.7.17-winx64/data/"Tmpdir=" D:\MySql\mysql-5.7.17-winx64/data/"Socket=" D:\MySql\mysql-5.7.17-winx64/data/mysql.sock"Log-error=" D:\MySql\mysql-5.7.17-winx64/data/mysql_error.log"#server_id=2#skip-Locking Max_connections= -Table_open_cache= thequery_cache_size=1M tmp_table_size=32M thread_cache_size=8Innodb_data_home_dir=" D:\MySql\mysql-5.7.5-m15-winx64/data/"Innodb_flush_log_at_trx_commit=1innodb_log_buffer_size=128M innodb_buffer_pool_size=128M innodb_log_file_size=10M innodb_thread_concurrency= -InnoDB-autoextend-increment= +join_buffer_size=128M sort_buffer_size=32M read_rnd_buffer_size=32M Max_allowed_packet=32M Explicit_defaults_for_timestamp=trueSQL-mode="strict_trans_tables,no_auto_create_user,no_engine_substitution"#sql_mode=no_engine_substitution,strict_trans_tables################### #配置文件结束 ###################

4. Add under Windows Path environment variable, YELLOW NOTE replace!!!

D:\mysql\mysql-5.7.  -winx64\ bin; (note plus semicolon)

5. Open the admin cmd and go to the/bin where the file directory is stored, yellow NOTE replace!!!

Mysqld Install MySQL--defaults-file="d:\mysql\mysql-5.7.  17-winx64\my.ini"

6. In cmd, enter

net start MySQL

hahaha, the MySQL service does not start, the service did not report any errors (dumbfounded!)

7. Workaround

Mysqld------initializenet start MySQL 

8. Now it is possible to use MySQL normally, the cmd command to start/stop MySQL is as follows

net start mysqlnet stop MySQL

Original address: http://www.cnblogs.com/HurryXin/p/6181661.html

How Windows installs Mysql-5.7.17-winx64.zip