How to realize the Chinese input of MYSQL under Ubuntu
This article will explain in detail how to realize the Chinese input of MYSQL under Ubuntu. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.
Ubuntu's MYSQL is installed using apt-get, which directly skips the process of configuration, so you cannot enter Chinese by default
1. Find the location of the cnf file for MySQL
Find /-iname'* .cnf'- print
/ etc/ssl/openssl.cnf
/ etc//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
two。 Direct configuration / etc/mysql/my.cnf file
3. Modify my.cnf
Vi / etc/my.cnf
Add under [client]
Default-character-set=utf8
Add under [mysqld]
Default-character-set=utf8
4. Restart MySQL
[root@bogon ~] # sudo / etc/init.d/mysql restart
Shutting down MySQL [OK]
Starting MySQL. [OK]
[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. View character set settin
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 |
| | 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 >
This is the end of the article on "how to realize the Chinese input of MYSQL under Ubuntu". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.
