Character set ‘utfmb4‘is not a compiled character set and is not specified......

最新推荐文章于 2023-06-21 14:41:03 发布
最新推荐文章于 2023-06-21 14:41:03 发布
阅读量666 收藏
点赞数 1
文章标签： mysql 数据库 database
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_60806689/article/details/122663547
版权

Mysql 在修改密码时出现

>mysql -uroot -p
mysql: Character set 'utfmb4' is not a compiled character set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\Index.xml'

原因时在my.ini 配置文件中的字符集写错了
在这里插入图片描述
修改为
在这里插入图片描述
再次输入命令就可以了
在这里插入图片描述

瀮寔
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
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, ...
mysql: Character set ‘utf8‘ is not a compiled character set and is not specified in the ‘C:\Program
闲言
03-01 9454
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
Character set 'utf-8' is not a compiled character set and is not specified
Vincent
12-04 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
django-vue-admin 使用Mariadb 连接提示Character set ‘utf8‘ is not a compiled character set解决
最新发布
mihaoyun.com的专栏
06-21 521
Character set 'utf8' is not a compiled character set解决
创建并导入已有数据库，Character set ‘ ... ‘ is not a compiled character set and is not specified in the ‘...‘
LinR12的博客
11-26 2795
Character set ' ... ' is not a compiled character set and is not specified in the '...' 操作系统：Win7； MySQL版本：mysql-5.7.21-winx64 问题产生情景：创建并导入已有数据库（ .sql）； 问题产生原因（猜测）：路径中的反斜杠符号（' \ '）被当成了转义符，如图1...
Mysql主从同步配置字符集问题解决
第一行代码
02-21 2406
Error ‘Character set ‘#255’ is not a compiled character set and is not specified in the ‘/usr/share/mysql/charsets/Index.xml’ file’ on query 这个问题是由于从库的数据库字符集中没有255编码对应的字符集，255在主库中对应的是utf8mb4，从库中也是有的，但是还是无法导入备份数据。 两个数据库的字符集都设置一样了，还是提示无法同步。 解决方案： 需要重新创建两个d.
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 ...
kgb档案压缩console版+源码
12-21
Decompression: No file names are specified. The archive must exist. If a path is stored, the file is extracted to the appropriate directory, which must exist. PAQ6 does not create directories. If the ...
MYSQL 8.0- MySQL 5.7 热备有坑
cllcgl1314的专栏
07-29 463
SHOW SLAVE STATUS; START SLAVE; SHOW SLAVE STATUS\G; SHOW MASTER STATUS; CHANGE MASTER TO MASTER_HOST='192.168.50.27', MASTER_HOST=3306, MASTER_USER='root', MASTER_PASSWORD='Pay12345!', master_log...
mysql登录时报错mysql: Character set ‘utf8；‘ is not a compiled character set and is not specified in the ‘
sy15140060721的博客
08-25 5621
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...
Character set 'utf8mb4' is not a compiled character set
热门推荐
乐沙弥的世界
12-19 1万+
最近在一次MySQL数据迁移的过程中遭遇了字符集的问题，提示为"Character set 'utf8mb4' is not a compiled character set"。即是字符集utf8mb4不是一个编译的字符集以及没有在Index.xml文件里指定。下面是其处理过程及解决办法，供大家参考。 1、错误提示SHELL>mysqlbinlog --database=bs_salary --s
mysqlbinlog: Character set '#45' is not a compiled character set and is not specified in the '/usr/s
arkblue的专栏
05-19 8448
执行mysqlbinlog 命令是遇到的异常。
mysql: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/sha
wxc20062006的专栏
02-20 1万+
1.场景：由于之前mysql中一起使用utf8编码，最近由于emoji表情的原因，需要使用utf8mb4编码 操作如下： 修改配置文件/etc/my.cnf： [client] default-character-set=utf8mb4 [mysqld] character-set-client-handshake=FALSE character-set-server=utf8m
mysql登陆数据库的时候报错：mysql: Character set 'utf8' is not a compiled character set and is not specified
ccityzh的博客
10-30 6375
mysql连接数据库的时候一直报错， 如下所示： 经检查后是配置文件my.ini文件中default-character-set=utf8设置的时候后面多加了个分号， 将分号去掉以后即可正常启动，
Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/
风泊月
09-10 1931
将my.ini（window） 或者my.cnf中 default-character-set = utf-8 改为 default-character-set = utf8 即可. linux批量替换的语法：%s/old/new/g 例子： :%s/utf-8/utf8/g; 最终效果： ...
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' 文件中被指定。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值