Window System MySQL cannot input and cannot display Chinese processing configuration

The first step : Use Notepad to open the "My.ini" file in the MySQL installation directory.

# MySQL Client library initialization. [Client]port=3306[MySQL]default-character-set=utf8

See if Default-character-set UTF8 is not UTF8 can be changed! (The previous version may not have this sentence directly added to the good!) ）

Step Two : Enter in MySQL database cmd: show variables like '%char% ';

This is what it looks like after the setting is successful.

Step three :

set character_set_database=UTF8; set character_set_server=UTF8; set character_set_client=GBK; set CHARACTER_SET_CONNECTION=GBK;

This is a configuration that can be inserted in Chinese, and these commands must be entered in CMD run MySQL.

Fourth Step:

Set CHARACTER_SET_RESULTS=GBK

This is the setting that can display the Chinese configuration. Get

Window System MySQL cannot input and cannot display Chinese processing configuration