mysql查询中文结果显示乱码的问题

问题：

mysql> select * from userinfo；
+-----+----------+------------+------------+
| uid | username | departname | created    |
+-----+----------+------------+------------+
|   1 | ??       | ???        | 2018-11-21 |
|   2 | ruby     | ???        | 2018-11-11 |
|   3 | ??       | ???        | 2018-11-21 |
|   4 | ruby     | ???        | 2018-11-11 |
+-----+----------+------------+------------+

1 输入命令，查看编码

mysql> show variables like'character_set_%';

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

2 更改为utf8编码

mysql> set character_set_results=utf8;

3 查看结果

mysql> select * from userinfo；
+-----+----------+------------+------------+
| uid | username | departname | created    |
+-----+----------+------------+------------+
|   1 | 韩茹   | 技术部  | 2018-11-21 |
|   2 | ruby     | 人事部  | 2018-11-11 |
|   3 | 韩茹   | 技术部  | 2018-11-21 |
|   4 | ruby     | 人事部  | 2018-11-11 |
+-----+----------+------------+------------+
4 rows in set (0.00 sec)

查看编码：

mysql> show variables like'character_set_%';
+--------------------------+--------------------------------+
| Variable_name            | Value                          |
+--------------------------+--------------------------------+
| character_set_client     | latin1                         |
| character_set_connection | latin1                         |
| character_set_database   | utf8mb4                        |
| character_set_filesystem | binary                         |
| character_set_results    | utf8                           |
| character_set_server     | utf8mb4                        |
| character_set_system     | utf8                           |
| character_sets_dir       | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+