Ubuntu下MYSQL的中文输入简析_MySQL

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