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

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

abccbatqw

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

阅读量2.6k

点赞数 1

文章标签： spring mysql java

本文链接：https://blog.csdn.net/abccbatqw/article/details/133561869

版权

严重: 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版本的