Ubuntu16.04下修改mysql编码为utf8

1.查看MySQL版本

mysql> select version();

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

| version()       |

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

| 5.7.12-0ubuntu1 |

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

1 row in set (0.00 sec)

 

2.查看当前MySQL的编码，有两处为latin1编码格式

 

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/ |

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

8 rows in set (0.00 sec)

 

3.修改/etc/mysql/my.conf文件，添加如下信息

 

[client]

default-character-set=utf8

 

[mysqld]

character-set-server=utf8

 

[mysql]

default-character-set=utf8

 

4.重启MySQL

sudo service mysql restart

 

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/ |

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

8 rows in set (0.00 sec)