2014-07-13 15:49:01
来 源
中存储网
mysqlcmd
当我们在Ubuntu下安装完MySQL后,一般都需要设置数据库的默认字符集。#先看看mysql中的默认字符集。#登入mysqlmysql -h localhost -u root -p#查看 character 相关的属性SHOW VARIABLES LIKE

当我们在Ubuntu下安装完MySQL后,一般都需要设置数据库的默认字符集。

#先看看mysql中的默认字符集。

#登入mysql

mysql -h localhost -u root -p

#查看 character 相关的属性

SHOW VARIABLES LIKE '%character%';

#会得到如下的结果:

+--------------------------+----------------------------+

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

#打开/etc/mysql/my.cnf

sudo gedit /etc/mysql/my.cnf

#在[client]内,添加 default-character-set 属性

[client]

...

...

default-character-set=utf8

#在[mysqld]内,添加default-character-set=utf8, character-set-server=utf8, default-collation=utf8_unicode_ci

[mysqld]

...

...

default-character-set=utf8

character-set-server=utf8

default-collation=utf8_unicode_ci

#重启 mysql

sudo service mysql restart

#再登进 mysql 看一下字符属性,得如下结果,ok,搞定了


+--------------------------+----------------------------+


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

声明: 此文观点不代表本站立场;转载须要保留原文链接;版权疑问请联系我们。