MYSQL不能连接了,错误ERROR 1129 (00000): Host ” is blocked because of many connection errors;
来源:互联网 发布:python参考手册 编辑:程序博客网 时间:2024/05/29 16:38
MYSQL连接报错,错误ERROR 1129 (00000): Host ” is blocked because of many connection errors;
有一次在工作中偶然遇到了这个问题,我的可以连接没问题,同事说数据库连不上,开始以为连接数太小了,后来发现连接数够大,于是上网查询到了解决方法:
错误的大意:有太多连到mysql服务器的连接,连到一半就断了,也就是说尝试连接mysql没有成功!
出错的原因:这个同事尝试登陆mysql次数太多了,并且都没有登陆成功~~
简单叙述连mysql的流程:
1.根据mysql的连接协议,发起握手,这在网络层面。
2.mysql服务器在内存上创建客户端连接的数据结构。
3.连接认证,就是看看客户端的权限,如用户名,密码允许不
4.监听端口,等待命令
解决办法:
执行mysqladmin flush-hosts命令或者 FLUSH HOSTS 命令
mysqladmin flush-host/* FLUSH HOSTS*/
说明:系统变量max_connect_errors设置了允许中断的次数,超过了这个次数,mysql就报上边的错,因为它觉得可能哪里有问题(难道是恶意攻击?),然后它就不让新的连接连了, 默认max_connect_errors 是10,但可动态调,不过调max_connect_errors 不是根本解决办法
0 0
- MYSQL不能连接了,错误ERROR 1129 (00000): Host ” is blocked because of many connection errors;
- Mysql ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with '
- Mysql连接错误:Mysql Host is blocked because of many connection errors
- Mysql连接错误:Mysql Host is blocked because of many connection errors
- mysql 1129 错误Host is blocked because of many connection errors; unblock with 'mysqladmin flush-host
- ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqla
- ERROR 1129 (00000) Host * is blocked because of many connection errors; unblock with ‘mysqlad解决
- ERROR 1129 (00000) Host * is blocked because of many connection errors; unblock with ‘mysqlad解决
- MYSQL:Host 'XXXXXX' is blocked because of many connection errors
- MySql Host is blocked because of many connection errors; unblock
- MySql Host is blocked because of many connection errors;
- mysql “Host is blocked because of many connection errors”
- MySQL无法连接[MySql Host is blocked because of many connection errors]
- ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock wit
- ERROR 1129 (HY000): Host '' is blocked because of many connection errors;
- mysql error 1129: Host 'bio.chip.org' is blocked because of many connection errors; unblock with 'my
- Host XXX is blocked because of many connection errors
- Host ‘XXXXXX’ is blocked because of many connection errors
- git命令汇总
- 工厂方法 Factory Method
- padding——图片文字的自适应布局
- Android Layouts(Fragment)详解
- 《剑指offer》合并两个有序的数组
- MYSQL不能连接了,错误ERROR 1129 (00000): Host ” is blocked because of many connection errors;
- 自定义View之onMeasure()
- Android .mk文件语法解析
- Linux下使用hydra获取linux和windows系统用户名和密码的教程
- C++11的bind,bind1st,bind2nd,function
- TCP/IP协议架构
- 还有太多的想看想学想准备
- 计算机中如何表示数字-05移码
- padding——使用padding来代替伪元素实现绘图