ubuntu mysql 中午_Ubuntu下MySQL的配置，使完美支持中文

安装完以后：

$:mysql -u root -p

查看字符编码初始值：

mysql> show variables like 'char%';

此时应该是：

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

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

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

修改字符集，不然对UTF-8的支持会出问题(看这里)：

$:cd /etc/mysql/

$:sudo gedit my.cnf

更改或加入：

[mysqld]下

default-character-set=utf8

如果启动不了，提示“mysqld: unknown variable 'default-character-set=utf8'”，则可换成：

character_set_server=utf8

[client]下

default-character-set=utf8

[server]下

default-character-set=utf8，init_connect='SET NAMES utf8;'

保存

重启SQL：

$:sudo /etc/init.d/mysql restart

查看字符编码初始值：

mysql> show variables like 'char%';

结果应为：

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

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

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

最后，创建DB时最好指明字符属性

$:create database database-name character set utf8