ubuntu
bitscn.com
ubuntu的mysql使用apt-get安装的，直接跳过了配置的过程，所以默认不能输入中文； 1.查找mysql的cnf文件的位置
 find / -iname '*.cnf' -print /etc/ssl/openssl.cnf/etc/mysql/debian.cnf/etc/mysql/conf.d/mysqld_safe_syslog.cnf/etc/mysql/my.cnf/usr/share/doc/mysql-server-5.1/examples/my-small.cnf/usr/share/ssl-cert/ssleay.cnf    /usr/lib/ssl/openssl.cnf 2. 直接配置/etc/mysql/my.cnf文件 3. 修改my.cnf
 vi /etc/my.cnf在[client]下添加default-character-set=utf8在[mysqld]下添加default-character-set=utf8 4.重新启动mysql
 [root@bogon ~]# sudo /etc/init.d/mysql restartshutting down mysql                                         [ 确定 ]starting mysql.                                             [ 确定 ][root@bogon ~]# mysql -u root -penter password:welcome to the mysql monitor. commands end with ; or /g.your mysql connection id is 1server version: 5.1.22-rc-community-log mysql community edition (gpl)type 'help;' or '/h' for help. type '/c' to clear the buffer. 5.查看字符集设置
 mysql> show variables like 'collation_%';+----------------------+-----------------+| variable_name         | value            |+----------------------+-----------------+| collation_connection | utf8_general_ci || collation_database    | utf8_general_ci || collation_server      | utf8_general_ci |+----------------------+-----------------+3 rows in set (0.02 sec)    mysql> show variables like 'character_set_%';+--------------------------+----------------------------+| 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/ |+--------------------------+----------------------------+8 rows in set (0.02 sec)mysql>   作者 chanthon bitscn.com