MySQL 5.6 Free Install version (green version or decompression version) to modify the code

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.