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