1、vi /etc/my.cnf
2、在[mysqld]的下面添加一行内容
default-character-set=utf8
3、重启mysql服务
service mysqld restart
如果还有乱码
进入数据库:
mysql -uroot -p123456
输入:
show variables like '%char%';
输入:
set character_set_client =utf8
输入:
set character_set_connection=utf8;
输入:
set character_set_results=utf8;
如果还是不行,
再将之前三个改为gb23121
set character_set_client=gb2312;
set character_set_connection=gb2312;
set character_set_results=gb2312;
这时候再查询
select * from dctest.author;
就是以上三个改成gb2312就行了
如果改成gb2312不行的话,再改成utf8