SecureCRT连接Mysql乱码

2019独角兽企业重金招聘Python工程师标准>>>

mysql> show variables like 'character_%';

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     | 
| character_set_connection | latin1                     | 
| character_set_database   | utf8                       | 
| character_set_filesystem | binary                     | 
| character_set_results    | latin1                     | 
| character_set_server     | utf8                       | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> set character_set_results=utf8 

mysql> set names utf8 ;

转载于:https://my.oschina.net/u/734592/blog/412346