Ubuntu上安装mysql 插入数据出现乱码,解决办法是修改my.cnf文件
在[cleant]中加入default-character-set = utf8,方法如下:
同时在[mysqld]中加入default-character-set = utf8,如下:
ok,重启mysql
修改成功!
xxx@xx:/etc/mysql$ sudo vim /etc/mysql/my.cnf
在[cleant]中加入default-character-set = utf8,方法如下:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
#
default-character-set = utf8
同时在[mysqld]中加入default-character-set = utf8,如下:
[mysqld]
# * Basic Settings
default-character-set = utf8
ok,重启mysql
xxx@xx:/etc/mysql$ sudo /etc/init.d/mysql restart
修改成功!