ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock wit

最新推荐文章于 2023-07-26 15:57:03 发布
原创 最新推荐文章于 2023-07-26 15:57:03 发布 · 3.7k 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
异常问题解决

当前文章被收录于：

异常问题解决
3 篇文章 0 人学习
订阅专栏 查看详情
当在MySQL中遇到主机'192.168.153.135'因连接错误被封锁的问题时，通过执行'db2 mysqladminflush-hosts'命令可以解除封锁并恢复连接。

相关IP：

db1: 192.168.153.135

db2:192.168.153.132

 

场景说明：

在db1上访问db2，使用以下语句：

mysql -uadmin -p123456 -h192.168.153.132


执行后错如下：

ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'


解决方法：

在db2上执行，'mysqladmin flush-hosts' 即可

 

 

Host is blocked because of many connection errors； unblock with ‘mysqladmin flush-hosts‘解决办法
所有文章免费阅读，请支持免费精神，为我评论和点赞。
06-06 3027
我在用abpvnext框架的 后台工作者写定时服务业务时，因为定时间隔设置的2秒，时间太短，然后频繁连接mysql。造成了如上错误提示，mysql直接被锁死不能连接了。他会提示要输入root密码，密码正确就执行成功了，我输入密码错了几次，所以failed几次了。执行命令：mysqladmin -u root -p flush-hosts。输入命令：dirname /usr/sbin/mysqld。(2)、进入mysql安装目录，然后执行命令解锁连接。(1)、连接linux，查看mysql的安装目录。
连接mysql提示被锁,“Host ‘xx‘ is blocked because of many connection errors； unblock with ‘mysqladmin ...“
hailishen的专栏
11-18 7778
多次连接mysql失败被锁后如何解锁
mysql连接1129错误Host is blocked because of many connection errors; unblock with 'mysqladmin flush-host'
weixin_44091482的博客
09-24 1万+
mysql连接出现如图 错误：Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ 原因：同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞； 解决方法： 1、提高允许的max_connectio...
1129 - Host ‘192.168.XX.XX‘ is blocked because of many connection errors； unblock with ‘mysqladmin报错
qq_16557863的博客
07-26 2745
mysql连接报错提示测试网络连通性，可以ping通和tel通mysql3306接口，怀疑是程序连接密码次数过多导致，
mysql 错误：Host is blocked because of many connection errors； unblock with ‘mysqladmin flush-hosts‘
xiaokungying的博客
03-17 3571
mysql 错误：Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 排查记录
从源码解析ERROR 1129 (HY000):Host is blocked because of many connection errors
cri5768的博客
06-01 787
原创水平有限,有错请指出 源码版本5.7.14 今天群里一个朋友出现如下错误： ERROR 1129 (HY000): Host '10.0.0.8' is blocked because of many conn...
ERROR 1129 (HY000): Host ‘192.168.0.1‘ is blocked because of many connection errors； unblock with ‘m
qq_35012243的博客
09-24 1636
MySql远程链接报错 问题： mysql -u root -h 192.168.0.1 -p Enter password: ERROR 1129 (HY000): Host '192.168.0.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决：在被链接服务器上执行如下 mysqladmin flush-hosts -u root -h192.168.0.1 -p .
Host ‘xxx‘ is blocked because of many connection errors； unblock with ‘mysqladmin flush-hosts‘
From_MKF的博客
12-13 1243
[HY000][1129] null, message from server: "Host 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'".
MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决方法...
weixin_30493401的博客
05-28 1494
环境：linux，mysql5.5.21 错误：Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 原因： 　　同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞； 解决方法： 1、提...
mysql连接flush-hosts问题处理
热门推荐
Freedom的blog
01-28 4万+
mysql连接flush-hosts问题处理 上网查到解决方案 【错误】Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’； 【原因】同一个ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)中断的数据库连接而导致的阻塞； 【解决...
host ‘192.168.xx.xx‘ is blocked because of many connection errors；unblock with ‘mysqladmin flush-ho‘
u012586389的博客
04-25 5381
host '192.168.xx.xx' is blocked because of many connection errors;unblock with 'mysqladmin flush-hosts'
message from server: "Host '192.168.1.9' is blocked because of many connection errors; unblock with
sakuragio的博客
09-28 2万+
MySql Host is blocked because of many connection errors 解决方法 环境：linux，mysql5.7.15 应用日志提示错误： create connection error, url: jdbc:mysql://10.45.236.235:3306/db_wang?useUnicode=true&characterEncoding=...
message from server: “Host ‘192.168.1.7‘ is blocked because of many connection errors； unblock with
来一杯Java的博客
06-07 2984
MySQL报错is blocked because of many connection errors;
MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts
shooke笔记
01-09 757
报错如下 SQLSTATE[HY000] [1129] Host '222.173.29.50' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 原因： 同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致...
Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
曹瑞祥的博客
06-17 990
一：今天一来公司，发现mysql连接不上了 二：网上查找了下错误，发现是因为（同一ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）终端的数据库连接而导致的阻塞；） 三：解决的办法：可以使用清楚缓存的方法。这样就会把计数清理掉。（到安装bin目录下，使用mysqladmin -u root -p flush-hosts命里 输入密码后，即完成清...
Host '192.168.210.79' is blocked because of many connection errors; unblock with 'mysqladmin flush-h
dearoracle的博客
09-28 1637
某台应用服务器连接数据库的时候报错：Host '192.168.210.79' is blocked because of many connection errors; unblock with 'mysqladmin flush-h 原因是网络原因导致该ip访问数据库被阻塞，多次失败，该ip被mysql屏蔽。(注意输错密码并不会导致这种情况) 查看最大错误连接数： MariaDB [info...
服务器端mysql连接时：报错 1129 (HY000): Host '' is blocked because of many connection errors;
落叶无痕的博客
12-03 5925
参考大佬的文章： MYSQL不能连接了，错误ERROR 1129 (00000): Host ” is blocked because of many connection errors; 出错原因是：一段时间内，重复多次连接msyql服务器，连接到一半就不连接了，并且没有登录成功  简述mysql连接流程： 1. 根据mysql连接协议，发起握手，在网络层面里 2. mysql服务器在...
HY000][1129] null, message from server: "Host '192.168.109.3' is blocked because of many connection
AKA石头
04-29 4527
今天使用idea连接mysql的时候报错误： ERROR 1129 (00000): #HY000Host ‘*192.168*.109*.3*’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ 解决办法： 使用mysqladmin flush-hosts命令清除缓...
Host '192.168.2.203' is blocked because of many connection errors;unblock with mysqladmin flush-host
卢克治-BJTU-NLP-的博客
05-07 2560
在通过datagrip连接mysql的时候，突然出现failed，提示如下：null,  message from server: "Host '192.168.2.203' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"原因：同一个ip在短时间内产生太多（超过mysql数据库...
mysql数据库 Host '192.168.XXX.XXX' is blocked because of many connection errors; unblock with 'mysqladm
人间正道
07-06 9463
问题描述：java启动程序报错错误 “Host ‘192.168.XXX.XXX’ is blocked because of many connection errors; unblock with ‘mysqladm” 原因：同一个ip在短时间内产生太多（超过mysql数据库max_connection_errors的最大值）中断的数据库连接而导致的阻塞 （短时间内链接错误次数过多） ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值