Host 'xxxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
来源:互联网 发布:js 7.62毫米狙击枪 编辑:程序博客网 时间:2024/05/30 04:15
原文地址:http://blog.600km.xyz/2015/12/15/mysql-host-is-blocked/
由于网络连接不稳定,在连接局域网内的mysql开发服务器时,连续多次断开,结果无法连接到mysql服务器,报错内容如下:
Host 'host_name' is blocked because of many connection errors.Unblock with 'mysqladmin flush-hosts'
这是mysql自带的一种保护机制,如果客户端连续连接失败次数max_connect_errors,超过默认值,则会拒绝客户端继续连接。
可以通过
SHOW VARIABLES LIKE 'max_connect_errors'
查看允许连接失败的次数,默认为100次。由于网络不稳,可能会让JDBC等连接很快超过此默认值,可以通过修改此默认值来避免出现连接失败的情形,如
SET GLOBAL max_connect_errors=10000;
如果本机已被拒绝连接,可以通过另一台可连接到mysql服务器的主机执行以下命令
mysqladmin flush-hosts -h localhost -uroot -p *****
此命令会清空所有的hosts缓存信息,执行后即可链接
Best regards
Wang Yuheng
0 0
- Host 'xxxx' 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' 解决方法
- 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'
- 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 'host_name' 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' 解决方法
- MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决方法
- VMware8安装配置Win7、CentOS-7向导
- 绑定服务
- ffmpeg 编译
- php tcp框架
- kinect+opencv之环境配置
- Host 'xxxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
- 位运算
- iOS 获取系统启动时间
- 网络层到运输层
- Zabbix 命令:zabbix_get
- python爬虫基础
- Acegi Security -- Spring下最优秀的安全系统
- 1023. 组个最小数
- libev安装