Host ‘XXXXXX’ is blocked because of many connection errors
发布:smiling 来源: PHP粉丝网 添加日期:2014-10-13 14:10:28 浏览: 评论:0
出现Host‘XXXXXX’ is blocked because of many connection errors这种错误我们只要在my.ini 修改set global max_connect_errors=1000;后面的1000是连接大小适当就可以了.
ERROR 1129 (00000): Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
这说明mysqld已经得到了大量(max_connect_errors)的主机’hostname’的在中途被中断了的连接请求。在 max_connect_errors次失败请求后,mysqld认为数据库出错了,并且阻止该站点进一步的连接,直到有人执行命令 mysqladmin flush-hosts。
缺省地,mysqld在10个连接错误后阻塞一台主机,你可以通过很容易地调整它:
set global max_connect_errors=1000; //phpfensi.com
注意,对给定的主机,如果得到这个错误消息,你应该首先检查该主机的TCP/IP连接有没有问题。如果你的TCP/IP连接不在运行,增加max_connect_errors变量的值也不会有帮助!
最后我们记得要重启mysql或 /usr/local/mysql/bin/mysqladmin flush-host -h 192.168.50.1 -uroot 哦,这样就可以解决问题了.
Tags: blocked because many connection errors
相关文章
- ·解决MySql Error:Host is blocked because of many connection errors问题(2014-09-24)
- ·解决Navicat cannot proceed because system tables办法(2014-09-24)
- ·Navicat 导出mysql数据库的时候出现 “Cannot proceed because system(2015-04-18)
- ·Mysql "Too many connections"错误解决办法(2014-09-24)
- ·mysql ERROR 1040: Too many connections(2014-10-02)
- ·MySQL连接too many connection错误并且启动时间特别长(2014-10-04)
- ·Mysql “Too many connections” 的解决方法(2014-10-04)
- ·LInux网站提示“Too many connections”的解决方法(2014-10-09)
- ·mysql出现too many connections错误提示(2014-10-14)
- ·mysql too many connections(2014-10-17)
- ·MYSQL提示 max_open_files: 2048 max_connections: 800 table_cache: 619(2014-09-23)
- ·ERROR 1040: Too many connections问题解决办法(2014-09-28)
- ·MySql Lost connection to MySQL server during query问题(2014-09-28)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)