Host XXX is blocked because of many connection errors
来源:互联网 发布:中级程序员考证培训费 编辑:程序博客网 时间:2024/05/18 14:46
连接MySQL失败,除了权限问题之外,还遇到这种情况,出错信息:Host XXX is blocked because of many connection errors, unblock with 'mysqladmin flush-hosts'。而且XXX还不是IP地址而是domain name。MySQL服务器和客户端在同一台测试及其上,连接的时候用的mysql -u root -h ipaddr。
查看机器的hosts配置,确实有domain name映射到本机地址,但是有变化,旧的已经注视掉,但错误信息显示的host name是注释掉的结果,应该跟缓存有关。
原因:MySQL服务器已经从某个host接收了大量中途终止的连接,于是决定终止继续接收来自该host的连接,允许最大的连接错误数为max_connect_errors,通过show variables命令可以查询,一般为10。
出现domain name而不是IP的原因是MySQL服务端在接收连接的时候会对客户端作DNS resolve,结果会被mysqld缓存,如果只用IP连接,可以在启动mysqld时加上-skip-name-resolve参数(命令行或my.cnf)。
解决方法:在另外一处地方执行mysqladmin flush-host或者登录进mysql执行flush hosts(本机host已经不允许登录!)。
- Host XXX is blocked because of many connection errors
- Host XXX is blocked because of many connection errors
- Host XXX is blocked because of many connection errors
- "Host 'xxx.xxx.xxx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-
- mysql errors:message from server: "Host 'xxx' is blocked because of many connection errors; unblock
- Host XXX is blocked because of many connection errors, unblock with 'mysqladmin flush-hosts
- null, message from server: "Host 'xxx' is blocked because of many connection errors; unblock
- MYSQL:Host 'XXXXXX' is blocked because of many connection errors
- MySql Host is blocked because of many connection errors; unblock
- Host ‘XXXXXX’ is blocked because of many connection errors
- MySql Host is blocked because of many connection errors;
- “Host is blocked because of many connection errors”问题解决
- mysql “Host is blocked because of many connection errors”
- mysql 1129 错误Host is blocked because of many connection errors; unblock with 'mysqladmin flush-host
- 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' 解决方法
- poj 2185(流的最小费用的充要条件)消负圈
- POJ 2318 TOYS (点与线段关系)
- Java、Tomcat、Android环境变量配置
- 具体的数据库操作类,Model类和DB类
- Pseudoclasses :first-child and :last-child for IE6
- Host XXX is blocked because of many connection errors
- SQL Server中的视图和查询语句的异同
- 有用的:nth-child秘方
- Oracle数据库监听配置
- poj1947(树形dp)
- Java 深拷贝
- NPOI 生成Excel 的——常用
- hdu_4342 History repeat itself (简单想法题)
- 最近半年计划