How to Set mysql encoding in Windows and Linux

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 &)