Ubuntu下MYSQL的中文输入简析
来源：未知 责任编辑：责任编辑 发表时间:2015-09-09 15:37 点击:次
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 www.2cto.com
/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 restart
Shutting down MySQL [ 确定 ]
Starting MySQL. [ 确定 ]
[root@bogon ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server 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) www.2cto.com
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>
