Shulou(Shulou.com)06/01 Report--

Editor to share with you what to do when the mysql command line displays garbled codes. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql command line display garbled solutions: 1, open the my.ini configuration file; 2, modify the configuration [default-character-set=utf8]; 3, change the database coding, such as [set character_set_connection=gb2312].

Solution:

1. Find the directory where mysql is installed and find the my.ini file

2. Use notepad to open the my.ini file and modify it according to the following configuration

# MySQL client library initialization.[client] port= 3306[mysql] default-character-set=utf8

3. Enter: in the mysql database cmd:

Show variables like'%char%'

4. Change the coding mode of the original database:

Set character_set_database=utf8;set character_set_server=utf8;set character_set_client=gb2312;set character_set_connection=gb2312; finished reading this article, I believe you have a certain understanding of the mysql command line display garbled code, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

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.