ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqla
来源:互联网 发布:基本的网络知识 编辑:程序博客网 时间:2024/04/27 09:21
查了下资料 --说明mysqld已经得到了大量(max_connect_errors)的主机'hostname'的在中途被中断了的连接请求。在 max_connect_errors次失败请求后,mysqld认定出错了(象来自一个黑客的攻击),并且阻止该站点进一步的连接,直到某人执行命令 mysqladmin flush-hosts。
缺省地,mysqld在10个连接错误后阻塞一台主机。
解决方案1:
你可以通过象这样启动服务器很容易地调整它: set global max_connect_errors=1000;注意,对给定的主机,如果得到这条错误消息,你应该首先检查该主机的TCP/IP连接有没有问题。如果你的TCP/IP连接不在运行,增加max_connect_errors变量的值对你也不会有帮助!
解决方案2:
重启MySQL服务器。
0 0
- ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqla
- Mysql ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with '
- 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 1129 错误Host is blocked because of many connection errors; unblock with 'mysqladmin flush-host
- mysql error 1129: Host 'bio.chip.org' is blocked because of many connection errors; unblock with 'my
- ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock wit
- MySql Host is blocked because of many connection errors; unblock
- MYSQL:Host 'XXXXXX' is blocked because of many connection errors
- Host ‘XXXXXX’ is blocked because of many connection errors
- MySql Host 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' 解决方法
- MySql Host 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' 解决方法
- MySql Host 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' 解决方法
- Host 'ETCV3' 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'
- firebird错误的查询语句引起的 System.Runtime.CompilerServices.ExtensionAttribute 无法载入异常
- 【总结】Python中第三方的库(library)、模块(module),包(package)的安装方法
- 报错:1130-host ... is not allowed to connect to this MySql server
- 【HNOI2012】射箭
- 怎么样更快提高锚文本外链的准确度
- ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqla
- FileUpload组件上传文件
- C6000的C语言优化
- android 缓存管理及LRU算法
- 1066N !最右边非零数
- CWinAppEx::CleanState函数的作用
- pack(1)的使用
- 性能loadrunner--loadrunner11如何显示回放过程
- 单片机串行收发电路制作记录