linux中mysql修改编码utf8

来源：互联网发布：网络投票编辑：程序博客网时间：2024/06/14 01:18

最近遇到mysql中文乱码的问题，更纠结的是在linux环境下，本人对于linux本身就是一片模糊，没办法只能硬着头皮改，

进入到mysql目录下

1.执行./client.sh,

2.show variables like 'char%'; 查询当前相关字符设置显示如下:

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

3.修改 mysql 的配置文件--/etc/my.cnf

4.打开配置文件

5.在[mysqld]下追加：（只在此处添加）

collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

注意：此处针对的是mysql的5.7版本，其配置文件下只有[client]和[mysqld]

,没有[mysql] ,之前参考的很多，但是都失败了，特此标注

6.重启mysql服务

./startServer.sh

7登录mysql查询

show variables like 'char%'

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

ok 到此修改成功

1 0