【Mysql】CentOS 环境下mysql 数据库字符编码设置

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

mysql 默认字符编码可能是Latin文，在存入和取出的时候回出现乱码的问题，所以需要给数据库重新编码

通过以下命令 查看mysql的字符集

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

为了让mysq不再出现乱码，需要把字符集编码改为 UTF-8

方法如下：

1.打开 etc/my.cnf

2.修改成如下内容，保存

[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8

[mysql]
no-auto-rehash
default-character-set=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

3.重启mysql服务：service mysqld restart

再次查看mysql编码，已经更新。

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

转载于:https://my.oschina.net/whitejavadog/blog/852297