Windows10下mysql5.5数据库命令行中文乱码怎么办
发布时间：2022-02-28 22:11:44 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要介绍Windows10下mysql5.5数据库命令行中文乱码怎么办，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ 打开安装目录下的my.ini文件 我的是：C:Program FilesMySQLMySQL Server 5.5下面，修改如下： [client] default
|
这篇文章主要介绍Windows10下mysql5.5数据库命令行中文乱码怎么办，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ 打开安装目录下的my.ini文件 我的是：C:Program FilesMySQLMySQL Server 5.5下面，修改如下： [client] default-character-set=utf8 port=3306 [mysql] #网上下面这个 gbk 很多回答也是设置为utf8，结果就是乱码 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 FilesMySQLMySQL Server 5.5sharecharsets | +--------------------------+---------------------------------------------------------+ 操作试试： 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) （编辑：ASP站长） 【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。 |
相关内容
未处理完善
-
无相关信息
最新更新