MySQL inserted in Chinese garbled

Reference: http://blog.csdn.net/zzh920625/article/details/51226312

Reference: http://soft.chinabyte.com/database/354/12643354.shtml

The simplest trick is to not modify the My.ini file:

1. Stop the MySQL service

2. Start: X:\%path%\mysql\mysql Server 5.0\bin\mysqlinstanceconfig.exe

This program is to reset the MySQL wizard. You can set the default MySQL encoding. There are 3 options, the default is Latin1, the second is Utf-8, and the third one is free to choose. Here I chose the second utf-8 directly.

3. After completing the Configuration wizard, MySQL will start automatically.

4. Open the MySQL command line and enter:

mysql> SHOW VARIABLES like ' character% ';

If shown below:

The MySQL encoding is modified successfully.

MySQL inserted in Chinese garbled