XAMPP MySQL under the Chinese is garbled

Http://www.2cto.com/database/201204/126775.html

Apache 80 ports are occupied

MySQL 3306 Port is occupied

The solution of MySQL Chinese garbled problem under XAMPP

Symptom Description: The MySQL database is built-in after the installation is complete XAMMP.  Create your own database---a new database table--add Chinese records to the table using JDBC---all the Chinese stored into garbled characters. www.2cto.com Problem Solving: 1. Locate the D:\xampp\mysql\bin\my.ini in the installation directory, open: 2, locate the tag [mysqld] and Mark [MySQL] 3, Add the encoding configuration information separately under these 2 tags: DEFAULT-CHARACTER-SET=GBK modified as follows: INI code [mysql] no-auto-rehash default-character-set=gbk www.2cto.c Om INI code [mysqld] port= 3306 CHARACTER-SET-SERVER=GBK 4, after the modification is complete, restart the MySQL database.   5, delete the old database, and create a new database, the new database can support the Chinese. Author huangqiqing123

XAMPP MySQL under the Chinese is garbled