MySQL 5.6 installation-free version (green or decompressed version) to modify the encoding, mysql5.6

MySQL 5.6 installation-free version (green or decompressed version) to modify the encoding, mysql5.6

See here: http://www.bkjia.com/sjkqy/989251.html

It took more than half an hour to try various methods on the Internet. It is estimated that the installation is normal. modify my. ini, but cannot find my. ini, found the my-default.ini, thought it is equivalent to modify this, it does not appear to be...

Method:
(1) copy the my-default.ini and rename it my. ini
(2) modify
(A) Add
Character_set_server = utf8
(B) SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
Add:
Port = 3306
Default-character-set = utf8

Restart MySQL and run the show variables like 'character % 'command ';
Then you can see

Now OK ~~

PS: one of the reasons why I hate development and the current search engine is that it takes a lot of time for new users to try different blog methods and may not solve the problem, the code can be changed easily. How many blog posts have I tried ....... Too much time wasted