Spring报错：create connection SQLException, url: jdbc:mysql://localhost:3306/mm, errorCode 1251, state

最新推荐文章于 2024-05-24 10:36:54 发布

windheart心随风

最新推荐文章于 2024-05-24 10:36:54 发布

阅读量3k

点赞数 1

CC 4.0 BY-SA版权

文章标签： spring mysql java

本文链接：https://blog.youkuaiyun.com/abccbatqw/article/details/133561869

文章讲述了在尝试连接MySQL8.0数据库时遇到的SQLException，原因是使用的mysql-connectjar包版本过低。解决方法是升级jar包至8.0版本以匹配服务器协议。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

严重: create connection SQLException, url: jdbc:mysql://localhost:3306/mm, errorCode 1251, state 08004
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not suppor

首先将url改成

<property name="url" value="jdbc:mysql://localhost:3306/mm?useSSL=false&amp;allowPublicKeyRetrieval=true&amp;serverTimezone=UTC" />

依然报错

create connection SQLException, url: jdbc:mysql://localhost:3306/mm?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC, errorCode 1251, state 08004
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

后来发现是mysql-connect的jar包版本不对，我连接的mysql数据库是8.0版本的