解决rpc再centos下安装的mysql的乱码问题

来源:互联网 发布:软件提示147 编辑:程序博客网 时间:2024/06/16 06:15

1、安装mysql之后默认的字符编码为latin1
登录mysql可以通过show variables like ‘%char%’查看,显示如下
这里写图片描述

2、进入/usr/share/mysql目录之后,拷贝my-medium.cnf 到/etc下,如果没有该文件则是my-default.cnf
这里写图片描述

在最后添加

[client]
#password = your_password
port = 3306
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#++++++++++++++++++++++++++++++++
character-set-server=utf8
character-set-client=utf8
collation-server=utf8_general_ci
#++++++++++++++++++++++++++++++++
skip-external-locking
[mysql]
no-auto-rehash
#Remove the next comment character if you are not familiar with SQL
#safe-updates
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++

保存退出

3、重启mysql服务    service mysql restart4、再次登录mysql,通过show variables like '%char%'查看,显示如下

这里写图片描述
ok,解决完毕

原创粉丝点击