MySQL encoding is set in Windows and Linux

The following article mainly describes how to configure MySQL encoding in Windows and Linux operating systems. This article mainly recommends two very useful methods, mySQL encoding settings for Windows and Linux operating systems. The following describes the specific content of the article.

Method 1

How to manually modify the default MySQL encoding for MySQL or 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 MySQL encoding, 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 &)

Very simple, this change once and for all, in the future MySQL All Related default MySQL encoding is UTF-8, create a new table without setting again

It should be noted that the existing data in the current database still retains the existing MySQL encoding method, so you need to perform transcoding on your own. There are many methods on the Internet, so we will not repeat them here.