Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem of displaying garbled code on mysql client". In daily operation, I believe many people have doubts about how to solve the problem of displaying garbled code on mysql client side. Xiaobian consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "how to solve the problem of displaying garbled code on mysql client side". Next, please follow the editor to study!

The client displays garbled codes and cannot display Chinese normally.

Modify the my.in as follows

[client]

Port=3306

Default-character-set=utf8

[mysql]

Default-character-set=utf8

[mysqld]

Port=3306

Default-character-set=utf8

Set default charset=utf8 for each table when you create a table

Then pass must pass through source mysqlFile.sql

To import cannot be imported through third-party tools

After that, we will ok.

At this point, the study on "how to solve the problem of mysql client display garbled" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.