Mysql Chinese garbled solution

Solution to mysql Chinese garbled code: 1. Find the my.cnf file in the Linux environment and modify the encoding; 2. Modify the my.ini file under Windows; 3. Forcibly set the character set during use coding.

Recommended: "mysql video tutorial"

1. Introduction

MySQL defaults to latin1 (actually ISO-8859-1) character set. This obviously does not meet our needs, so we adjusted it to the UTF8 character set to be compatible with most character sets.

1. First execute two SQLs to detect the current MySQL default character set encoding:

Sql command:

mysql>show variables like "%colla%";

Sql command:

mysql>show variables like "%char%";

2. Modify the character set to UTF-8

You need to modify the MySQL configuration file my.cnf file, and the Windows environment is my.inidocument.

Usually in linux environmentmy.cnfThe file is located in/etc/mysql/my.cnf(/etc/my.cnf ) path, but due to different installation versions or system environments, we may not be able to find the file in this directory

1. Modification method under Linux

Modify the mysql configuration file, because the newly installed mysql may not have my.cnf under etc

This needs to be created by yourself one. Find a my-medium.cnf file and copy it to the etc folder. The command is: cp /usr/share/doc/MySQL-server-5.5.24/my-medium.cnf /etc/my.cnf

Shell code:

#echo Modify my.cnf file

#sudo vi /etc/my.cnf

Under [client] Add code:

default-character-set=UTF8

Add code under [mysqld]:

character_set_server=utf8

Add the code under [mysql]:

default-character-set=utf8

Some images are as follows:

Restart the mysql database after the modification is successful.

Shell command:

service mysql restart

Sometimes the database service mysql start starts successfully, but you can only use the mysql command at root. It may be because the firewall is not closed. Use The following command solves the problem:

service iptables stop

Then query the character set：

show variables like '%character% ';

show variables like "%colla%";

The successful image is as follows:

2. Modification method under Windows

Change the my-default.ini in the MySQL installation directory to the my.ini file

[client]Node

default-character-set=utf8 (Add)

[mysql]Node

default-character-set=utf8 (Modify)

[mysqld]Node

character_set_server=utf8 (Modify)

Use after modification

net stop mysql

net start mysql

Restart the mysql service

Then query the character set:

show variables like '%character%';

show variables like " %colla%";

3. Forcibly set the character set encoding during use
In order to ensure that the character set is completely unified, a unified character set must be forcibly set when building tables and databases.
In addition, in order to ensure nothing goes wrong when connecting to MySQL through JDBC, the following parameters need to be added to the connection string:

jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF- 8

The above is the detailed content of Mysql Chinese garbled solution. For more information, please follow other related articles on the PHP Chinese website!