mysql 设置 utf-8-优快云博客

本文介绍如何将MySQL服务器的字符集从latin1更改为utf8，包括修改my.cnf配置文件，重启MySQL服务以及验证字符集更改的效果。

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

 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.01 sec)
 
 
 sudo vi /etc/mysql/my.cnf
 
[mysqld]
character_set_server=utf8 
init_connect='SET NAMES utf8' 

sudo /etc/init.d/mysql restart

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)

转载于:https://my.oschina.net/thinker4self/blog/504416