远程连接服务器数据库报错:Host ‘XXXXXX’ is blocked because of many connection errors
来源:互联网 发布:万达乐园和迪士尼 知乎 编辑:程序博客网 时间:2024/05/17 20:30
一、我遇到的问题描述
使用Navicat for mysql连接公司的服务器数据库,报错:Host ‘XXXXXX’ is blocked because of many connection errors
二、出现错误原因
同意ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)终端的数据库连接而导致的阻塞;
三、解决方案(根据实际情况来选择解决方案):
1、可以更改max_connection_errors的值,即提高允许的max_connection_errors的数量
(1)首先查看该属性设置为多大:命令:show global variables like '%max_connect_errors%';
(2)然后修改该属性
(3)再次查看
(4)如果需要永久解决问题
如果需要永久生效,得去修改mysql配置文件里相应属性。可能配置文件里没有这个属性,需要自己手动添加
(5)注意:
当客户端连接服务端超时(超过connect_timeout), 服务端就会给这个客户端记录一次error,当出错的次数达到max_connect_errors的时候,这个客户端就会被锁定。所以根据业务来尽量把这个值设置大一点,mysql默认值为10,我们可以根据具体需要设置大一点,这里设置为1000.(并非越大越好,越大被攻击时安全性越低)
2、使用清楚缓存的方法,这样就会把计数清理掉,进入mysql控制台,执行:flush hosts;
四、借鉴地址
https://jingyan.baidu.com/album/9f7e7ec087dcbe6f2815542d.html 点击打开链接
- 远程连接服务器数据库报错:Host ‘XXXXXX’ is blocked because of many connection errors
- MYSQL:Host 'XXXXXX' is blocked because of many connection errors
- Host ‘XXXXXX’ is blocked because of many connection errors
- 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 '
- mysql 连接报错:Host is blocked because of many connection errors; unblock with 'mysqladmin flush-h
- mysql 连接报错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 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;
- “Host 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; unblock with 'mysqladmin flush-hosts'
- Mysql连接错误:Mysql Host is blocked because of many connection errors
- MySQL无法连接[MySql Host is blocked because of many connection errors]
- MYSQL不能连接了,错误ERROR 1129 (00000): Host ” is blocked because of many connection errors;
- java 设计模式整理(方便记忆)
- SAS学习︱逻辑库、数据集创建与查看、数据库链接(SAS与R的code对照)
- MongoDB集群搭建
- 《二》取消关注并删除用户信息
- ffplay中的parse_options()分析
- 远程连接服务器数据库报错:Host ‘XXXXXX’ is blocked because of many connection errors
- 【备忘】动力节点MySQL数据库视频 86集下载
- ReentrantLock源码解析
- Python 容器API
- Java中常用进制转换
- Lintcode 463 整数排序
- WPF架构分析
- Linux 内核文件系统关键数据结构
- KMP子字符串查找算法.java