“Host is blocked because of many connection errors”问题解决
来源:互联网 发布:金川公司网络学校2017 编辑:程序博客网 时间:2024/05/22 17:32
环境
Linux、MySQL 5.5
报错
Host ‘hostname’ is blocked because of many connection errors; unblock with 'mysqladmi.
原因
该host上部署的服务因数据库帐号配置错误,导致短时间内连接MySQL服务失败次数超过max_connection_errors参数设定值(默认10),从而被拒绝。
解决方法
方法一:
刷新记录报错host的文件
mysqladmin -uroot -p -h192.168.1.1 flush-hosts
或
mysql>flush hosts;
注意:数据库主从服务器要确定是被哪个MySQL服务拒绝了,刷新对应的服务器即可,不确定的话就都刷新吧。
方法二:
进入数据库将max_connection_errors参数调高,也可以在my.cnf文件中修改不过需要重启MySQL。
mysql>show variables like '%max_connection_errors%';mysql>set global max_connect_errors = 1000;mysql>show variables like '%max_connection_errors%';
阅读全文
0 0
- “Host is blocked because of many connection errors”问题解决
- MYSQL:Host 'XXXXXX' is blocked because of many connection errors
- Host XXX 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
- Host XXX is blocked because of many connection errors
- Host XXX is blocked because of many connection errors
- MySql Host is blocked because of many connection errors;
- mysql “Host is blocked because of many connection errors”
- mysql errors:message from server: "Host 'xxx' is blocked because of many connection errors; unblock
- 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' 解决方法
- MySql Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' 解决方法
- 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 with 'mysqladmin flush-hosts' 解决方法
- Centos7安装并配置mysql5.6
- Linux-ubuntu连接投影仪失败(分辨率不匹配)问题解决
- Hive环境搭建
- 存在多个版本的python时,如何为特定的版本安装包
- java多线程(四)wait() notify() notifyall()
- “Host is blocked because of many connection errors”问题解决
- 卡特兰数
- DataTables columnDefs和columns取值问题
- linux下编译faad2-2.7
- getline函数的用法
- cookie设置、获取、删除
- Android 反射机制的理解
- Salty Fish
- 长文干货助UI设计师拿高薪