重置系統(tǒng)后，很久之前安裝的MySQL數(shù)據(jù)庫出現(xiàn)了控制臺查詢中文亂碼問題，本文主要和大家分享Windows10下mysql5.5數(shù)據(jù)庫命令行中文亂碼解決方案，希望能幫助到大家。

打開安裝目錄下的my.ini文件

我的是：C:\Program Files\MySQL\MySQL Server 5.5下面，修改如下：

[client]
default-character-set=utf8
port=3306
[mysql]
#網(wǎng)上下面這個 gbk 很多回答也是設(shè)置為utf8，結(jié)果就是亂碼
default-character-set=gbk
# SERVER SECTION
# ----------------------------------------------------------------------
## The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.5/"
#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8
collation-server=utf8_general_ci
修改完畢重啟mysql，查看一下編碼：
mysql> show variables like 'character_set%';
+--------------------------+---------------------------------------------------------+  
Variable_name   Value  
+--------------------------+---------------------------------------------------------+ 
 character_set_client   gbk    
character_set_connection   gbk   
 character_set_database   utf8    
character_set_filesystem   binary    
character_set_results   gbk    
character_set_server   utf8   
 character_set_system   utf8   
 character_sets_dir   C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\  
+--------------------------+---------------------------------------------------------+
操作試試：
mysql> insert into per values('亂碼解決');
Query OK, 1 row affected (0.00 sec)
mysql> select * from per;
+--------------+  
name  
+--------------+  
的紛紛從   
 亂碼解決  
+--------------+
3 rows in set (0.00 sec)

相關(guān)推薦：

詳解mysql數(shù)據(jù)庫中文亂碼問題

MySQL插入數(shù)據(jù)時遇到中文亂碼改怎么辦？

php如何解決中文亂碼問題？

以上就是Windows10下mysql5.5數(shù)據(jù)庫命令行中文亂碼解決方案的詳細內(nèi)容，更多請關(guān)注php中文網(wǎng)其它相關(guān)文章！