Mysql+toad for MySQL installation, configuration and import of Chinese data to solve problems such as garbled

1. Download the MySQL5.7 version, install the official version of the Windows Installer on the Internet: https://dev.mysql.com/downloads/windows/installer/5.7.html

Install the selected development development version, the default installation on the line.

2. Download toadformysql_freeware_7.9.0.637 My network address HTTPS://PAN.BAIDU.COM/S/1TBVIJUVWHPZURXMXQX-SWW

3. In Toad, the options setting starts the connection when it is started

Next time you start the pop-up connection window, enter your username root password: Set When you install MySQL yourself

3. Open SQL Editor in Toad

Indicates that the test connection was successful

4. Import Chinese table

Tools--import, view table structure, collation for UTF-8 description support Chinese

The import results are normal.

5, if the Chinese import in garbled

In Toad for MySQL to create a new editor (PL/SQL query Statements and command statements are to create a different window, I did not think Toad for MySQL is not used directly an editor window to fix). Input
SHOW VARIABLES like ' character_set_% ';
SHOW VARIABLES like ' collation_% ';

Found it

C:\ProgramData\MySQL\MySQL Server 5.7 Under My.ini file, add Default-character-set=utf8

[Mysqld]
Character-set-server = UTF8
[Mysqld]
Character-set-filesystem = UTF8

Mysql+toad for MySQL installation, configuration and import of Chinese data to solve problems such as garbled