Reproduced MySQL5.5 configuration file My.ini 1067 error

Original link: http://blog.csdn.net/xiaochunyong/article/details/7438200

After extracting Mysql-5.5.22-win32.zip, there are 5 My-xxxx.ini configuration files in the directory,

By looking at the description in the configuration file, the recommended configuration for different memory sizes is stated.

This example copies the My-medium.ini and renames it to My.ini and adds the following lines:

[Client]

Default-character-set=utf8 Client-side encoding

[Mysqld]

Basedir=d:/sdk/mysql MySQL installation directory
Datadir=d:/servers/mysql/data MySQL Database storage directory
Default-character-set=utf8 Server-side encoding
Default-collation=utf8_general_ci server-side character set

2. Install Windows Service (Windows7 user must start cmd with Administrator):

3. Start the Windows service

The results reported 1067 errors ....

To the boot log file view (the boot log is in the MySQL data directory, because this example specifies datadir in the My.ini file, my log file is D:\Servers\mysql\data\Siuon-PC.err):

Say the unknown variable ' Default-character-set=utf8 ' ... Remember the company's MySQL configuration inside is like this ah ... So Google's ... Originally because I downloaded the MySQL version is 5.5 ...

Several variables that have just been configured in this release have been replaced by new ones.

Default-character-set---character_set_server P.s:[mysqld] part of the Default-character-set

Default-collation-Collation-server

After you have finished modifying:

Restart, or 1067 error is reported. The logs are:

It means that the Mysql.host table does not exist. This is because I changed the datadir to custom, but the system databases in the DataDir directory (that is, mysql/data) were not copied together to the new DataDir directory. Caused by.

Copy the following folders into the new My.ini configuration file datadir The specified directory (in this case, the D:\Servers\mysql\data directory):

To start the MySQL service ok~~~:

Another: MySQL5.6 's My.ini configuration: http://www.cnblogs.com/Candies/p/4014523.html

Reproduced MySQL5.5 configuration file My.ini 1067 error