Default writing for different versions of the MySQL character set

Originally in the 5.1 version, in order to solve the Chinese garbled problem set the default character set is UTF8, in the My.ini in the [MySQL] and [mysqld] entries are written:

INI Code

1. Default-character-set=utf8

In the 5.5 version, [MySQL] can write this in the [mysqld] item, but it must be written:

INI Code

1. Character-set-server=utf8

Otherwise there will be a 1067 error when starting the MySQL service.

5.1 and 5.5 are now known to have such a difference and are seen in the auto-generated My.ini file from the 5.5 installation version.

Default writing for different versions of the MySQL character set