MySQL 5.6.26 The difference between several installation packages

http://downloads.mysql.com/archives/community/

First, MySQL Installer 5.6.26

Mysql-installer-community-5.6.26.0.msi, 364.2MB
MySQL Installer provides an easy-to-use, wizard-based installation experience for MySQL software (currently only supported by Windows), including the following products: MySQL Server, all connectors,workbench and sample models, sample databases, Document. The installation package chatty.

Second, MySQL Community Server 5.6.26

A, Mysql-5.6.26-win32.msi, 34.7MB

B, Mysql-5.6.26-win32.zip, 343.9MB

The A and B above are actually equivalent. A need to install, B is a green compression package. Both A and B require the user to configure themselves. Take B as an example:

1. Copy the My-default.ini in the root directory after decompression, rename to My.ini save to the same path

2. Modify My.ini
[Mysqld]

# set up the MySQL installation directory, if the directory with spaces must be quoted
Basedir = "C:\Program files\mysql\mysql Server 5.6"

# Set the data storage directory for the MySQL database, the folder name must be
DataDir = "C:\Program files\mysql\mysql Server 5.6\data"

#设置数据库引擎为INNODB
Default-storage-engine=innodb

# set MySQL server encoding
Character_set_server=utf8

# setting up the MySQL server character set
Collation-server=utf8_general_ci
Port = 3306
server_id = 1

[Client]
Default-character-set = UTF8

[Winmysqladmin]
Server = "C:\Program files\mysql\mysql server 5.6\bin\mysqladmin.exe"

3. Install MySQL Service
To enter directory C:\Program files\mysql\mysql Server 5.6\bin from the MS-DOS window, run the following command:
Mysqld--install

4. Start MySQL Database
Also in the command window above, enter the command: net start MySQL
This launches the MySQL service. You can start at windows--run-services.msc to see the MySQL process.

5. Delete Service
Execute mysqld--remove to

6. Set Root password
Perform mysqladmin-u root password 123456

7, we recommend the use of visual third-party tools Navicat for MySQL.

MySQL 5.6.26 The difference between several installation packages