设置Mysql数据库的默认编码为utf8
![](http://www.gravatar.com/avatar/6dfeddd9c8263e4fa53fc377ba0832c7.jpg?alt=sunny&s=30)
mysql的默认编码为latin1,存储中文时总会出现乱码,每次改过了,下次又忘了该怎么配,把它记录下来,也分享给各位。
进入mysql,查看默认编码:
- $ mysql -uroot -proot
-
- $ show variables like character%'
显示字符编码:
- +--------------------------+----------------------------+
-
- | 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/ |
-
- +--------------------------+----------------------------+
现暂停mysql服务:
$sudo /etc/init.d/mysql stop
修改 /etc/mysql/my.cnf
- $ sudo chmod 777 /etc/mysql/my.cnf
-
- $ vim