Ubuntu下MYSQL的中文输入简析_MySQL
程序员文章站
2023-12-25 20:56:09
...
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
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