The perfect solution to the Chinese garbled characters in mysql6.x under win7

1. Stop the MySQL service in the command line: net stop mysql stop mysql

2. Modify my.ini in the mysql installation directory and change default-character-set=latin to default-character-set=gbk (change several to several, I don't know if it is possible to change to utf-8)

3. Copy the newly modified my.ini to the C:\Windows directory and overwrite it.

4. Start the MySQL service in the command line: net start mysql , enter MySQL

5. Input: show variables like 'char%'; see which ones are latin

6. For example: character_set_database是latin , then enter set character_set_database=gbk ; until there is no latin. (Note: character_set_filesystem and character_set_system cannot be changed)

7. Only databases built after this will support Chinese encoding, so the original database can be deleted and rebuilt (I don’t know how to modify the encoding of a specified database yet).

Related references:

MySQL 5.6 (Win7 64-bit) download, installation and configuration graphic tutorial

How to configure php+Apache+mysql environment in win7 system

The above is the perfect solution to the Chinese garbled characters in mysql6.x under win7 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. Thank you very much for your support of the 123WORDPRESS.COM website!