HDP SQLException : SQL state: HY000 java.sql.SQLException: null, message from server:

80后大叔爱学习

已于 2022-07-15 05:44:46 修改

阅读量826

点赞数

CC 4.0 BY-SA版权

分类专栏： HDP MySQL 文章标签： mysql centos 数据库

于 2020-08-29 10:56:43 首次发布

本文链接：https://blog.csdn.net/walykyy/article/details/108291893

HDP 同时被 2 个专栏收录

28 篇文章 ¥59.90 ¥99.00

订阅专栏

超级会员免费看

MySQL

37 篇文章

订阅专栏

博客内容提到遇到一个SQLException，原因是使用了与MySQL 5.7不兼容的8.0版本mysql-connector-java.jar。解决方法是查找并替换所有路径下的过期jar包。通过在CentOS系统中运行'find / -name mysql-connector-java.jar'命令，找到了需要替换的jar包位置。

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

全部错误：

2020-08-29 00:38:52,849  [JISQL] /usr/java/current/bin/java  -cp /usr/hdp/current/ranger-admin/ews/lib/mysql-connector-java.jar:/usr/hdp/current/ranger-admin/jisql/lib/* org.apache.util.sql.Jisql -driver mysqlconj -cstring jdbc:mysql://ambari.wanfeng16899.com/ranger -u 'rangeradmin' -p '********' -noheader -trim -c \;  -query "select 1;"
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
SQLException : SQL state: HY000 java.sql.SQLException: null,  message from server: "Host '192.168.0.182' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" ErrorCode: 1129
2020-08-

了解本专栏