Solving the problem of MySQL writing data garbled

MySQL default encoding is Latin.

My MySQL version is 5.6. There is no My.ini under the installation path, but there is my-default.ini. In fact, MySQL does not have a configuration file can also be started, but in order to set the encoding, you need to change My-default.ini to My.int.

Then modify the Character-set-server=utf8under [MySQL], [mysqld]Character-set-server=utf8

Reboot.

If you still have a problem, you can view the%mysql%/data/xxx.err log file

Solving the problem of MySQL writing data garbled