达梦数据库：迁移工具DMDTS报：unknown initial character set index 45

最新推荐文章于 2023-09-07 10:21:21 发布
原创 最新推荐文章于 2023-09-07 10:21:21 发布 · 870 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库

本文解决达梦数据库迁移工具 DMDTS 连接 MySQL 5.7.24 版本时出现的 unknowninitialcharactersetindex45 错误。原因是 DMDTS 默认驱动仅支持 MySQL 5.0.* 版本，需手动指定适用于 MySQL 5.7.* 的驱动。提供了解决方案及正确的驱动下载链接。

达梦数据库：迁移工具DMDTS报：unknown initial character set index 45

使用达梦数据库工具DMDTS ，数据源是mysql-5.7.24
在新建迁移时，创建数据源报

unknown initial character set index 45

详细的如图：
达梦迁移工具DMDTS报错

原因为DMDTS自带的驱动对应的mysql的版本为mysql-5.0.*
所以需要指定驱动
mysql-5.7.*对应的驱动下载链接为：
链接：

https://pan.baidu.com/s/1zmYg-rivSzvy0UVJ_ZaS0A

提取码：

6k56

指定驱动后，可以正常连接mysql啦！！！

【MySQL】MySQL 8报错 Unknown initial character set index 255 received from server. Initial client char
九师兄
06-27 1722
1.背景 背景请参考：【MySQL】MySQL 8 IDEA连接本地MySQL报错 Host DESKTOP-MISSMJIJ is not allowed to connect to this serv 根据上述操作后报错 Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' propert.
Unknown initial character set index '45'
旅行的胶布的专栏
12-19 409
测试后发现是mysql的my.cnf中 [mysqld] character_set_server=utf8 #修改为对应的字符集编码 collation_server=utf8_general_ci #修改为对应的编码 做如上修改即可解决， ...
Unknown initial character set index '45' received from server. Initial client ch
tengxg的专栏
10-16 780
Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'characterEncoding' property. 最初遇到这个问题，到网上查了一下，很多人都说是编码问题，并且好像符合错误的描述，但是经过我的不断判断与实验...
Unknown initial character set index '45' received from server
e891377的专栏
10-08 1708
出现这个数据库连接异常，可能是你们数据库太新，所以更新一下JDBC连接驱动，原来的是5.0.4 ，现在换成5.1.47.连接成功。 Unknown initial character set index '45' received from server. Initial client character set can be forced via the 'chara ...
Unknown initial character set index '45'问题
geqian0的博客
05-13 8038
前两天把在学校机房上的写好的一个小项目拷到自己电脑上，运行时就报了： Unknown initial character set index '45' received from server.java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client c
mysql问题，Unknown initial character set index '45' received from server
YueQingFeng445的博客
06-07 1983
mySQL安装后出现问题，eclipse编写插入汉字代码，出现标题错误和数据库中两个问号的问题。1.文件修改    复制my-default.ini文件，重命名为my.ini；这样根目录下就有两个.ini文件了，一个是my-default.ini，一个是my.ini。接下来我们只需修改my.ini里面的内容就行了；2.修改my.ini添加两行：default-character-set=utf8 ...
解决：Unknown initial character set index ‘255‘ received from server 问题
BeJav
06-10 776
转移项目的时候遇到一个bug： Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 网上找到的解决方法是： 在数据库地址后面加上，?characterEncoding=utf8 如： jdbc:mysql://127.0.0.1/itcaststore?characte
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
最新发布
06-26
在 Java 连接数据库时，出现 `java.sql.SQLException: Unknown initial character set index '255' received from server` 错误通常与 MySQL 数据库服务器和客户端之间的字符集配置不匹配有关。此问题常见于使用较新...
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '255'
06-01
这个错误通常是由于 JDBC 驱动程序无法识别数据库字符集引起的。这可能是由于以下原因之一导致的： 1. JDBC 驱动程序版本过旧，无法识别数据库字符集。 2. 数据库字符集设置不正确或不兼容 JDBC 驱动程序。 3. ...
SQL State: S1000 Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
06-01
这个错误通常是由于数据库连接字符集不匹配导致的，可以尝试...3. 确保数据库中使用的字符集与连接字符集匹配，可以通过以下 SQL 语句查看：SHOW VARIABLES LIKE 'character%'; 希望这些解决方法能够帮助你解决问题。
java.sql.SQLException Unknown initial character set index 45 received from server. Initial client
EraWalker的博客
06-04 834
java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 问题出现原因大多数使用了MySQL5.5的其他一些版本，java项目的部分jar包连接就会出现问题。比如今天看到出问题的就是 MySQL5.5 MariaDB 解决办法： 官方下
Unknown initial character set index ‘45‘ received from server.java.sql.SQLException: Unknown initial
此时彼刻的蜗牛
10-22 736
Unknown initial character set index ‘45’ received from server.java.sql.SQLException: Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. 解决方案： 1.MySQL版本低，需要升级 如果安装的
java.sql.SQLException: Unknown initial character set index '45' received from server.
keyboard专栏
07-09 2529
启动tomcat，链接mysql出现如下的错误，查询日志因为mysql大小写问题，程序里组装的mysql都是大写的sql，执行到mysql，mysql找不到对应的大写的mysql的表。 java.sql.SQLException: Unknown initial character set index '45' received from server. Initial client charac...
Unknown initial character set index ‘45’ received
allgame029的博客
05-10 332
Unknown initial character set index ‘45’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property. mysql jar 的版本问题, 同时lib下不能有多个jar。 mysql-connector-java-5.1.30
【已解决】Unknown initial character set index ‘45‘ received from server
yeliner的博客
09-07 554
出现这个数据库连接异常，可能是数据库太新，所以更新一下JDBC连接驱动，原来的是5.0.4 ，现在换成5.1.47.连接成功。
Unknown initial character set index '45' received from serve
u012752013的博客
07-08 5778
由于mysql6.0版本，更换一个jdbc的驱动可解决问题
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial clien
inexaustible的博客
11-27 1063
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property. at com.mysql.jdbc.SQLError.c...
关于"xampp中mysql中配置问题:Unknown initial character set index '48' received from server错误解决方法"
05-05 8167
一个老生常谈的问题: 错误提示:Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

祢真伟大

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值