The zip package for MySQL in Windows environment is streamlined with the installation.

Use this method to reduce the MySQL Zip installation package from more than 300 m to 6 m.

Mysql

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

Streamline process

1. Leave only [Data/bin/share] in the root directory, My-default.ini

2. Only [mysqladmin/mysql/mysqld] EXE file is left under bin

3. Share only [Charsets/english] directory and all files below

4. Only the [MySQL] directory and all of its files are left under data

Modifying a configuration file

[Mysqld]

Basedir=c:\program Files\mysql\mysql Server 5.6

Datadir=c:\program Files\mysql\mysql Server 5.6\data

Character_set_server=utf8

Init_connect = ' SET NAMES UTF8 '

Collation-server=utf8_general_ci

#sql_mode =no_engine_substitution,strict_trans_tables

Port = 3306

[Client]

Port = 3306

Default-character-set = UTF8

Host=localhost

User= ' Root '

password= ' Root '

# Remove Leading # and set to the amount of RAM for the most important data

# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

[MySQL]

Default-character-set = UTF8

Remove the last line

Sql_mode=no_engine_substitution,strict_trans_tables

Installation process:

1. Unzip the Mysql.zip package into the C:\Program Files

   650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/96/D8/wKiom1kmOuPjJAqkAAAf-QYIWxk110.png-wh_500x0-wm_ 3-wmp_4-s_663498258.png "title=" image 1.png "alt=" Wkiom1kmoupjjaqkaaaf-qyiwxk110.png-wh_50 "/>

   2. Add the MySQL environment variable

   
   

   Open the computer and select System Properties.

   650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/96/D9/wKioL1kmOybRpYkIAAAysy7naJ8618.png-wh_500x0-wm_ 3-wmp_4-s_1108604246.png "style=" Float:none; "title=" Picture 3.png "alt=" Wkiol1kmoybrpykiaaaysy7naj8618.png-wh_50 "/>

   Select Advanced System Settings

   650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/96/D8/wKiom1kmOyihpadLAAAf6hBIEzM997.png-wh_500x0-wm_ 3-wmp_4-s_3643424040.png "style=" Float:none; "title=" Picture 4.png "alt=" Wkiom1kmoyihpadlaaaf6hbiezm997.png-wh_50 "/>

   Select "Advanced", "Environment variable".

   650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/96/D9/wKioL1kmOyihr7pSAAAipUtrqn8115.png-wh_500x0-wm_ 3-wmp_4-s_4146311845.png "style=" Float:none; "title=" Picture 5.png "alt=" Wkiol1kmoyihr7psaaaiputrqn8115.png-wh_50 "/>

   Adding environment variables

   650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/96/D8/wKiom1kmOyjwjiEBAAAgTMnG_fg507.png-wh_500x0-wm_ 3-wmp_4-s_3159455621.png "style=" Float:none; "title=" Picture 6.png "alt=" Wkiom1kmoyjwjiebaaagtmng_fg507.png-wh_50 "/>

   650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/96/D9/wKioL1kmOyjz4_DrAAAOCiN5LyQ697.png-wh_500x0-wm_ 3-wmp_4-s_2622545109.png "style=" Float:none; "title=" Picture 7.png "alt=" Wkiol1kmoyjz4_draaaocin5lyq697.png-wh_50 "/>

   Add the C:\Program files\mysql\mysql Server 5.6\bin to the Path, separated by;

   3. Installation

   CMD runs with administrator privileges

   CD C:\Program files\mysql\mysql Server 5.6\bin

   Mysqld--install MySQL--defaults-file= "C:\Program files\mysql\mysql Server 5.6\my-default.ini"

   4. Start the service

   Input net start MySQL (stop service is stop)

   5. Login

   Enter MySQL direct carriage return.

This article is from the "Hibiki Technology Workshop" blog, please be sure to keep this source http://hibiki.blog.51cto.com/12625187/1929231

The zip package for MySQL in Windows environment is streamlined with the installation.