How to set mysql encoding in Windows and Linux _ MySQL

How to set mysql encoding in Windows and Linux systems: bitsCN.com

Method 1
How to manually modify the default encoding of MySQL and later versions

Use the php5 + MySQL 4.1.x/5.x environment:
Mysql4 is prone to Chinese garbled characters when importing mysql5. Therefore, you must first make the following settings:
Assume that mysql is installed in the c:/mysql directory.
1: Start-run. enter cmd and press enter.
2: Enter cd c:/mysql/bin and press enter.
3: enter mysql -- default-character-set = gbk-u root-p and press enter.
Next, you will be prompted to enter the password, press the Enter key, and then restart mysql.

Note: gbk represents simplified Chinese in mainland China

Method 2
MySQL default character encoding settings
MySQL default encoding is Latin1, does not support Chinese, so how to modify the default encoding of MySQL, the following UTF-8 as an example to explain

It should be noted that there are many changes and there are many corresponding modification methods. The following is the simplest and most thorough method:

I. Windows
1. stop the MySQL service
2, in the installation directory of MySQL find my. ini, if not, copy the my-medium.ini as a my. ini
3. after opening my. ini, add default-character-set = utf8 under [client] and [mysqld], save and close
4. start the MySQL service

II. Linux
1. stop MySQL service (bin/mysqladmin-u root shutdown)
2. find my under/etc. cnf, if not, copy the my-medium.cnf under the support-files directory under the MySQL installation directory to/etc/and rename it to my. cnf
3. after opening my. cnf, add default-character-set = utf8 under [client] and [mysqld], save and close
4. start MySQL service (bin/mysqld_safe &)

BitsCN.com