java.sql.SQLException: null, message from server: "Host '10.21.5.91' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
选中数据库----刷新----权限
重启mysql
/etc/init.d/mysqld restart
or
/etc/init.d/mysqld restart
1、可以使用mysqladmin flush-hosts 命令清理一下hosts文件;
mysqladmin flush-hosts -h iphost -P port -u root -prootpasswd;
2、或者试试下面的方法 1.提高max_connection_errors数量:
(1)修改max_connection_errors的数量为1000:
set global max_connect_errors=1000;
(2) 查看是否修改成功:
SHOW GLOBAL VARIABLES LIKE '%max_connect_errors%';
参考:https://blog.csdn.net/weixin_45126177/article/details/119395463 https://blog.csdn.net/qq_40965479/article/details/105833415 https://segmentfault.com/a/1190000040256955