MySQL5.5 中文无法输入问题解决

it2022-05-05  132

mysql> status;        //查看数据库状态--------------c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe  Ver 14.14 Distrib 5.5.8, for Win32 (x86)

Connection id:          2Current database:Current user:          SSL:                    Not in useUsing delimiter:        ;Server version:         5.5.8-log MySQL Community Server (GPL)Protocol version:       10Connection:             localhost via TCP/IPServer characterset:    latin1Db     characterset:    latin1Client characterset:    gbkConn.  characterset:    gbkTCP port:               3306Uptime:                 1 min 44 sec

Threads: 1  Questions: 16  Slow queries: 0  Opens: 35  Flush tables: 1  Open tables: 28  Queries per second avg: 0.153--------------

看到字符集是lantin1时,则需设置gbk后才能显示中文(不然显示将是一串??????)打开MySQL配置文件my.ini,随意找块空白贴上下面四行:

[client]default-character-set = gbk[mysqld]character-set-server = gbk

重启mysql,进入mysql> status;  //再次查看

--------------c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe  Ver 14.14 Distrib 5.5.8, for Win32 (x86)

Connection id:          3Current database:Current user:          SSL:                    Not in useUsing delimiter:        ;Server version:         5.5.8-log MySQL Community Server (GPL)Protocol version:       10Connection:             localhost via TCP/IPServer characterset:    gbkDb     characterset:    gbkClient characterset:    gbkConn.  characterset:    gbkTCP port:               3306Uptime:                 6 min 10 sec

Threads: 1  Questions: 19  Slow queries: 0  Opens: 35  Flush tables: 1  Open tables: 28  Queries per second avg: 0.51

--------------

OK,此时,已可以向数据库输入中文!

转载于:https://www.cnblogs.com/Gatsby/archive/2013/04/26/3045078.html

相关资源:DirectX修复工具V4.0增强版

最新回复(0)