Character set 'utf-8' is not a compiled character set and is not specified

最新推荐文章于 2024-07-03 11:23:24 发布
最新推荐文章于 2024-07-03 11:23:24 发布
阅读量1.2w 收藏 5
点赞数 7
分类专栏： Mysql Linux 文章标签： character mysql utf-8
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/JQ_AK47/article/details/53452977
版权
Linux 同时被 2 个专栏收录
40 篇文章 0 订阅
订阅专栏
Mysql
13 篇文章 1 订阅
订阅专栏

我在terminal登入mysql时候，如报下面错误：Mysql提示说你要在/usr/share/mysql/charsets/Index.xml文件将缺失的编码集加入，但是我检查后发现在Index.xml文件中有我需要的编码集。

这个链接给出答案对我有效

Character set 'utf-8' is not a compiled character set and is not
specified in the '/usr/share/mysql/charsets/Index.xml' file

当出现“Character set ‘utf-8’ is not a compiled character set and is not specifie”的错误时，将mysql安装目录下的my.ini文件的default-character-set=utf-8更改为default-character-set=utf8即可.
简单来说就是将”utf-8”更改为”utf8”即可。

JQ_AK47
关注
  • 7
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 6
    评论
专栏目录
详谈mysqldump数据导出的问题
09-09
下面小编就为大家带来一篇详谈mysqldump数据导出的问题。小编觉得挺不错的，现在就分享给大家，也给大家做个参考。一起跟随小编过来看看吧
MySQL常见错误
m0_52151912的博客
05-17 793
1.Character set ‘utf-8’ is not a compiled character set and is not specifie 翻译：" utf-8不是编译字符集，也没有指定" 解决方法：将mysql安装目录下的my.ini文件的default-character-set=utf-8更改为default-character-set=utf8即可 2.Can’t connect to MySQL server on ‘localhost’ (10061) 翻译：无法连.
python文件运行时遇见NOT-UTF-8问题时的格式处理例子展示
最新发布
qq_45938544的博客
07-03 465
注意：可直接看解决方法2，永久解决改问题，因为笔者在学习的过程中发现每次创建新的python文件运行都会出现同一个错误，所以找到了第二个办法，就不用每次重复设置
django-vue-admin 使用Mariadb 连接提示Character set ‘utf8‘ is not a compiled character set解决
mihaoyun.com的专栏
06-21 546
Character set 'utf8' is not a compiled character set解决
mysql登录时报错mysql: Character set ‘utf8；‘ is not a compiled character set and is not specified in the ‘
sy15140060721的博客
08-25 5779
MySQL Command Line Client打不开时报错 或者cmd进入数据库报错 错误提示为mysql: Character set 'utf8;' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index.xml' file. 解决方法为找到my.ini文件 我的文件位置为C:\Program Files (x86)\MySQL\MySQL Se...
mysql常见命令错误
DN金猿的博客
10-09 1269
目录 【1】Can't initialize character set utf8] (path: /usr/share/mysql/charsets/) 【2】Character set 'utf-8' is not a compiled character set and is not specified 【3】Mysql：Character set 'utf8mb4' is not a compiled character set ... 解决方案 参考文件 【1】Can't initial.
Character set 'utf-8' is not a compiled character set and is not specifie
hzbigdog的专栏
04-20 3766
mysql如果遇到: Character set 'utf-8' is not a compiled character set and is not specifie 时候 打开mysql安装目录，找到my.ini将default-character-set=utf-8修改为default-character-set=utf8
MySQL4 File ‘c:\mysql\share\charsets\?.conf’ not found (Errcode: 22)的解决方法
12-15
.conf’ not found (Errcode: 22) Character set ‘#33′ is not a compiled character set and is not specified in the ‘c:\mysql\share\charsets\Index’ file 查阅一番后基本可以确定原因为低版本的PHP和高版本...
php.ini-development
05-08
directive because it is not set or is mistyped, a default value will be used. ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, ...
Bochs - The cross platform IA-32 (x86) emulator
03-14
- Local APIC configure option --enable-apic is deprecated and should not be used anymore. The LAPIC option now automatically determined from other configure options. XAPIC functionality could be ...
ICS delphixe10源码版
05-03
ICS V7 is a stable release that may still be updated for major bugs, but not for new releases of Delphi, latest it supported was XE3. ICS V8 is the current development release which is held in a ...
Turbo C 2.01[DISK]
08-05
using the Z-449 with a monitor that is not compatible with this mode, it will be necessary to override the GraphDriver and GraphMode parameters used in the BGI initgraph() call. 4. ADDITIONAL ...
Turbo C 2.00[DISK]
08-05
using the Z-449 with a monitor that is not compatible with this mode, it will be necessary to override the GraphDriver and GraphMode parameters used in the BGI initgraph() call. 4. CORRECTIONS ...
kgb档案压缩console版+源码
12-21
model is a distribution over the next character, y_i, given the context of characters seen so far, y_1 ... y_i-1. To simplify coding, PAQ6 uses a binary string alphabet. Thus, the output of a model ...
acpi控制笔记本风扇转速
04-16
When this mode is specified, instead of creating a serialization semaphore per control method, the interpreter lock is simply no longer released before a blocking operation during control method ...
VclZip pro v3.10.1
03-03
- If a file does not extend beyond any of the original limitations (filesizes of 4 gig or 65535 files) then no Zip64 format information is included in the archive. - property isZip64 - tells you when ...
mysql: Character set ‘utf8‘ is not a compiled character set and is not specified in the ‘C:\Program
闲言
03-01 9538
mysql: Character set 'utf8' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\Index.xml' file
3D EM-Pen emulator
liuxs2009的专栏
10-12 1320
# # -*- coding: utf-8 -*- # """ # This example uses the isosurface function to convert a scalar field # (a hydrogen orbital) into a mesh for 3D display. # """ # # ## Add path to library (just for examples; you do not need this) # # import initExample # # .
character set 'utf8</pre>' is not a compiled character set and is not specified in the 'c:\program files\mysql\mysql server 8.0\share\charsets\index.xml' file
03-16
这个错误提示是说字符集 'utf8' 没有被编译进 MySQL 中，并且也没有在 'c:\program files\mysql\mysql server 8.\share\charsets\index.xml' 文件中被指定。
评论 6
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值