MySQL Compression pack installation (5.6.40)

One, download the MySQL compressed package file

: http://dev.mysql.com/downloads/mysql/

Second, the compression package decompression installation

Can be installed on any system disk

1, configure the My.ini file.

　　In D:\Java\ Mysql-5.6.40-winx64 (Note that this directory and your own directory, I download the 5.6 version, if you download the 5.5 version, this directory is not the same) directory to create a new configuration file, the file named My.ini, and then copy the following configuration code to the My.ini (the path in the code To change to their own file storage path).

　Code:

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
# set up the MySQL installation directory
Basedir=d:\java\mysql-5.6.40-winx64
# Set up a storage directory for MySQL database data
DataDir =d:\java\mysql-5.6.40-winx64\data
#设置3306端口
port=3306
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb
# server_id = ...

# Remove Leading # To set options mainly useful for reporting servers.
# The server defaults is faster for transactions and fast selects.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

Sql_mode=no_engine_substitution,strict_trans_tables

2. Install MySQL service:

　　Under MySQL's Bin directory, press and hold shift+ right mouse button and select "Open Command Window Here" to do the following:

3. Start MySQL Service

Control Panel-"management tool-" service-"mysql-" start.

MySQL Compression pack installation (5.6.40)