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

Source: Internet
Author: User
Tags toad for mysql

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.