Client does not support authentication protocol requested by server； consider upgrading MySQL client

最新推荐文章于 2023-08-02 23:30:05 发布
最新推荐文章于 2023-08-02 23:30:05 发布
阅读量1k 收藏
点赞数 2
分类专栏： error 文章标签： mysql maven java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_52875557/article/details/121352808
版权

原本报错信息如下：

D:\Java\jdk-13.0.1\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\IntelliJ IDEA 2021.1.1\lib\idea_rt.jar=59211:D:\IntelliJ IDEA 2021.1.1\bin" -Dfile.encoding=UTF-8 -classpath "D:\IntelliJ IDEA 2021.1.1\lib\idea_rt.jar;D:\IntelliJ IDEA 2021.1.1\plugins\junit\lib\junit5-rt.jar;D:\IntelliJ IDEA 2021.1.1\plugins\junit\lib\junit-rt.jar;D:\Java\untitled4\target\test-classes;D:\Java\untitled4\target\classes;D:\maven\apache-maven-3.8.2\pohome\junit\junit\4.11\junit-4.11.jar;D:\maven\apache-maven-3.8.2\pohome\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\maven\apache-maven-3.8.2\pohome\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;D:\maven\apache-maven-3.8.2\pohome\mysql\mysql-connector-java\5.1.9\mysql-connector-java-5.1.9.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 com.zwz.MyBatisTest,testStart

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
### The error may exist in com/zwz/dao/StudentDao.xml
### The error may involve com.zwz.dao.StudentDao.selectStudents
### The error occurred while executing a query
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:135)
	at com.zwz.MyBatisTest.testStart(MyBatisTest.java:26)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:221)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:201)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.doGetConnection(UnpooledDataSource.java:196)
	at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:93)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:403)
	at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:89)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:138)
	at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:60)
	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	... 25 more


Process finished with exit code -1

大概意思就是客户端不支持服务器请求的认证协议;考虑升级MySQL客户端。

随后我看了看自己的mysql版本，发现为

 

 于是在maven依赖中修改了版本号

发现还是报错

后来又查看了mybatis的maven依赖版本号

把它更新到最新版本

 最后运行：还是报错，错误情况如下

 意思是新版本的mysql驱动路径对于之前的路径要加一个  cj

修改后

 解决！

 

今天你学习了ma
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
专栏目录
mysql4.1以上版本连接时出现Client does not support authentication protocol问题解决办法
10-30
在MySQL 4.1及更高版本中，由于采用了新的基于密码哈希算法的身份验证协议，与旧版客户端使用的协议不兼容，可能会遇到“Client does not support authentication protocol requested by server; consider upgrading...
用root用户登陆PHPmyAdmin出现Client does not support authentication ...
10-01
PHPmyAdmin 是一个基于 Web 的 MySQL 数据库管理工具，但是有时候当我们使用 root 用户登录 PHPmyAdmin 时，可能会出现 "Client does not support authentication protocol requested by server; consider ...
IDEA连接mysql数据库权限出错 Client does not support authentication protocol requested by server； consider upg
weixin_57997644的博客
08-02 830
IDEA连接mysql数据库权限出错 Client does not support authentication protocol requested by server;
Client does not support authentication protocol requested by server; consider upgrading MySQL client
博客&brz
01-09 643
今天使用MySQL往数据库插入数据时IDEA报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client. 解决方法： use mysql; alter user 'root'@'localhost' identified with mysql_n...
idea用JDBC连接mysql数据库时报错Client does not support authentication protocol requested by server的解决方法
Kary的博客
05-17 1881
idea用JDBC连接mysql数据库时报错Client does not support authentication protocol requested by server的解决方法解决办法 解决办法 在Mysql解压的根目录下，我这里是C:\Program Files\MySQL\MySQL Server 8.0,按住shift键+右键，点击运行命令行窗口 如果没有，就直接在文件地址栏输入cmd并回车 打开命令行窗口后，输入 mysql -uroot -p密码 （-u后是数据库用户名，
关于idea用JDBC连接mysql数据库时报错Client does not support authentication protocol requested by server的解决方法
qq_37753562的博客
02-26 507
参考idea用JDBC连接mysql数据库时报错Client does not support authentication protocol requested by server的解决方法_Kary的博客-CSDN博客
IDEA报错Client does not support authentication protocol requested by server；
游吟焰火的博客
04-05 5186
使用IDEA进行jdbc开发时报错 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client 原因 项目使用的m...
解决Navicat Premium 连接 MySQL 8.0 报错1251的问题分析
12-14
在尝试使用Navicat Premium连接MySQL 8.0数据库时，可能会遇到错误1251，提示“Client does not support authentication protocol requested by server; consider upgrading MySQL client”。此问题的根源在于MySQL ...
mysql8.0旧客户端连接报1251错误
06-20
这个变化对旧版的客户端（如Navicat for MySQL 8.0.4之前版本）造成了不兼容，导致了"1251 Client does not support authentication protocol requested by server; consider upgrading MySQL client"的错误提示。 ...
文件拷贝工具FastCopy
11-24
FastCopy是一款高效、轻量级的文件拷贝工具，尤其在大量数据传输和备份场景下表现出色。它以其快速的拷贝速度和稳定的性能而受到用户的喜爱，是IT专业人士和普通用户进行文件管理的重要助手。 ...
Idea连接本地数据库报Client does not support authentication protocol requested by server
qq_33581381的博客
09-28 937
详见https://my.oschina.net/u/3295928/blog/1811804
Docker安装Mysql使用Navicat连接报错（client does not support authentication protocol requested by server co...
zhangchao的博客
01-30 507
# 进入容器 docker exec -it mysql01 bash //mysql01是mysql容器的别名 # 进入mysql mysql -uroot -p //-uroot #重置密码 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; ALTER USER 'root'@'...
外部连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
weixin_45259565的博客
11-16 4526
1.按照mysql8.0 p 53306:3306 将docker容器的3306端口映射到宿主机的63306端口 -e MYSQL_ROOT_PASSWORD=wangbo root用户登录密码为wangbo --name my_mysql新建容器的名称为my_mysql mysql:8.0 使用的mysql数据库版本为8.0 2.进入容器 docker exec -it my_mysql ...
Client does not support authentication protocol requested by server
热门推荐
Gary的博客
07-17 1万+
Navicat连接报错 Client does not support authentication protocol requested by server 由于个人电脑原因，mysql5.7被我废了，这次又换回了mysql8.0。安装过程中有个坑踩了挺久：我走的是之前mysql本地服务，但是服务路径还没有改过来=，需要先卸载掉之前的mysql本地服务，再重新安装mysql8.0的服务，不然mysql8.0服务起不来 安装完mysql8.0以后，利用初始密码换了个新密码 用Navicat可视化工具连
Navicat for mysql 报错Client does not support authentication protocol requested by server亲测
Sun的专栏
12-14 778
Navicat for mysql 报错 Client does not support authentication protocol requested by server 亲测可用办法 //创建新用户 用户名@授权ip create user 'root'@'%' identified by 'qwe123'; //修改密码加密方式 ALTER USER 'sunwork'@'%' IDENTIFIED WITH mysql_native_password BY 'qwe123'; /
idea中连接mysql插入成功数据 在navicat中刷新表格没有数据_MySQL mysql-8.0.21-winx64 数据库的下载与安装...
weixin_40001442的博客
11-28 246
一篇好文章：https://blog.csdn.net/bobo553443/article/details/81383194mysql官网地址：https://dev.mysql.com/downloads/mysql下载解压后进入该文件的bin目录(注意目录最好不要有中文或特殊字符)，此方法不需要设置环境变量与my.ini文件，可在地址栏输入cmd进入命令行模式（需要管理员身份）1.输入mys...
client does not support authentication protocol requested by server consider upgrading MySQL Client
最新发布
10-20
这个错误通常是由于 MySQL 服务器使用了比... ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; ``` 其中，'username' 和 'password' 分别是您要更改的用户名和密码。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

打赏作者

今天你学习了ma

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

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

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

打赏作者

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

抵扣说明：

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

余额充值