Reference here: http://www.bkjia.com/sjkqy/989251.html
Spent more than half an hour, tried the various methods on the Internet, is estimated to be normal installation, modify My.ini, but in their own MySQL folder can not find My.ini, found My-default.ini, thought equivalent to modify this, it seems not ...
Method:
(1) Copy My-default.ini and rename to My.ini
(2) Modification of two places
(a) [Mysqld] under Add
Character_set_server = UTF8
(b) Sql_mode=no_engine_substitution,strict_trans_tables
Add the following:
port=3306
Default-character-set=utf8
Restart MySQL, using the command SHOW VARIABLES like ' character% ';
You can then see
It's OK now.
PS: Hate the development and now the search engine one reason is, for the novice, need to spend a lot of time to try the methods of each blog, may or cannot solve the problem, see the code so easy to change, I tried how many blog proposed method ah ... waste too much time
MySQL 5.6 Free Install version (green version or decompression version) to modify the code