Solution to MySQL Chinese garbled characters problem

1. The Chinese garbled characters appear in MySQL in Linux. The following operations are performed

Edit the vi /etc/my.cnf file and add the three lines marked in the figure

[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
[mysql]
default-character-set=utf8

Restart mysql service

2. Chinese garbled characters appear when the Navicat tool connects to the database

View the encoding format in the edit connection

View the encoding format in the editing database

View the character set in the table design table

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.