将mysql编码改变成utf8：

0.先查看编码：

show variables like '%character%';

mysql>show variables like '%character%';

+--------------------------+----------------------------+

|Variable_name            | Value                      |

+--------------------------+----------------------------+

|character_set_client     | utf8                       |

|character_set_connection | utf8                       |

|character_set_database   | latin1                      |

|character_set_filesystem | binary                     |

|character_set_results    | utf8                       |

|character_set_server     | latin1                      |

|character_set_system     | utf8                       |

|character_sets_dir|/usr/share/mysql/charsets/

1.关闭mysql：

sudo service mysql stop

2.修改权限：

sudo chmod 666 /etc/mysql/my.cnf

改动：[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

[mysql]

default-character-set=utf8

保存！！

3.修改后重新赋予权限

sudo chmod 644 /etc/mysql/my.cnf

4.重启：

sudo service mysql start

5.进入mysql后输入

mysql>show variables like '%character%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

|character_sets_dir|/usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

---

(没有实践过)另外一种方法:

直接命令行修改