怎么解决java链接mysql报错？

Question

我把spring+springboot+mybatis的项目打包成jar，部署到windows服务器上，能运行。但请求就报这个错误。mysql版本是5.1.51。

Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: null,  message from server: "Host 'shunda-sbtemy91' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"] with root cause

这个怎么解决呀？

Answer 1

链接mysql的版本太高，以前的依赖是这样的：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

改后是这样，指定低一点的版本。

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.37</version>
    <scope>runtime</scope>
</dependency>

然后 6的版本 .yml的驱动是这样，com.mysql.cj.jdbc.Driver。现在改成5了，所以这边也得对应改成com.mysql.jdbc.Driver