MySQL Import data Chinese garbled _ubuntu

1. In Ubuntu, the part of MySQL encoding format is not utf-8, so in the document will appear in Chinese garbled, Windows encoding format is GBK, so to modify MySQL encoding method is utf-8.

2. View the MySQL encoding format:

A. Enter MySQL

B. Input

1  like '%chart%';

3. Modify the Encoding Method (permanent):

Enter Termina:

A. Input: sudo vi/etc/Mysql/my.cnf or sudo vi/etc/Mysql/Conf.d/MYSQL.CNF (MYSQL5.7. 16 and later) Note: The configuration file location differs by version B. Add:[MySQL]    default-character-Set=UTF8[Client]    default-character-Set=UTF8[mysqld]    character-Set-Server=utf8c. Restarting MySQL services: service MySQL stop service MySQL start

# # # #新手小白, please correct me

MySQL Import data Chinese garbled _ubuntu