Windows10下mysql5.5數(shù)據(jù)庫(kù)命令行中文亂碼怎么辦

這篇文章主要介紹Windows10下MySQL5.5數(shù)據(jù)庫(kù)命令行中文亂碼怎么辦，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

在襄垣等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供成都做網(wǎng)站、成都網(wǎng)站制作網(wǎng)站設(shè)計(jì)制作按需定制制作,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站設(shè)計(jì),成都全網(wǎng)營(yíng)銷,成都外貿(mào)網(wǎng)站建設(shè)公司,襄垣網(wǎng)站建設(shè)費(fèi)用合理。

打開(kāi)安裝目錄下的my.ini文件

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

[client]
default-character-set=utf8
port=3306
[mysql]
#網(wǎng)上下面這個(gè) 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)

以上是Windows10下mysql5.5數(shù)據(jù)庫(kù)命令行中文亂碼怎么辦的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

網(wǎng)站題目：Windows10下mysql5.5數(shù)據(jù)庫(kù)命令行中文亂碼怎么辦
分享地址：http://m.jiaotiyi.com/article/pgcscg.html

網(wǎng)站建設(shè)知識(shí)

Windows10下mysql5.5數(shù)據(jù)庫(kù)命令行中文亂碼怎么辦

其他資訊