How to modify MySQL encoding in Linux

Source: Internet
Author: User
Sometimes, because the encoding needs to modify the mysql encoding, it is easier to modify the graphic interface in windows. For linux, you can refer to the following method.

Sometimes, because the encoding needs to modify the mysql encoding, it is easier to modify the graphic interface in windows. For linux, you can refer to the following method.

After logging on to mysql by default

Mysql> show variables like '% character % ';

Copy/usr/share/doc/mysql-server-5.1.52/my-large.cnf to/etc/my. cnf

Command: cp/usr/share/doc/mysql-server-5.1.52/my-large.cnf/etc/my. cnf

Add default-character-set = utf8 under [client]

Add default-character-set = utf8 under [mysqld]

Even if the above changes are made, if the database directly creates a table and then stores the table in Chinese, the question mark is obtained. The solution is to specify the default Character Set utf8 when creating a database, for example:

Create database test default character set utf8;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.