Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.