Mysql5.6.24 Zip Decompression version Configuration and modify the default encoding method

Win64 bit:

http://dev.mysql.com/downloads/file.php?id=456319

Unzip after download is complete

Configuring Environment variables

After path, add MySQL after decompression bin folder location such as D:\Program Files\mysql-5.6.24\mysql-5.6.24-winx64\bin

Configure My-default.ini

# basedir = D:\Program files\mysql-5.6.24\mysql-5.6.24-winx64

# DataDir = D:\Program Files\mysql-5.6.24\mysql-5.6.24-winx64\data

Installation Services

Open cmd as administrator enter the directory where the bin is entered Mysqld-install

The prompt after successful installation is service successfully installed.

Modifying the default encoding

Duplicate a copy of My-default.ini rename to My.ini Open

Under [Mysqld], add:

Character_set_server=utf8

Under Sql_mode=no_engine_substitution,strict_trans_tables, add:

[Client]

port=3306
Default-character-set=utf8

Start/Stop Service

NET Start/stop MySQL

Go to MySQL

Mysql-u root//initial password is empty

Mysql5.6.24 Zip Decompression version Configuration and modify the default encoding method