`

解决MySql “Host is blocked because of many connection error” 的问题

阅读更多

      这些天,连接MySql出现了

     Host is blocked because of many connection error” In MySQL的问题,从网上搜索了一些解决方式,现记录如下:

      Today, I got following MySQL error in a PHP application: Host ‘host_name’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’. It means that mysqld has received many connection requests from the given host. Default max_connect_errors value is 10, that is remote host will be blocked if there is more than 10 connection errors.

To fix, type the following command

# mysqladmin flush-hosts

To avoid this happening again, edit my.cnf

# vi /etc/my.cnf

Add the following line

max_connect_errors=10000

The value of the max_connect_errors system variable determines how many successive interrupted connection requests are permitted. Restart MySQL to reload configuration file

# service mysqld restart

Or, the value ‘max_connect_errors’ can also be set at runtime, type the following commands

# mysql -uroot -p
# mysql> SET GLOBAL max_connect_errors=10000;
分享到:
评论

相关推荐

    Your page is blocked due to a security的解决方案

    关于Your page is blocked due to a security的解决方案

    解决mysql出现大量TIME_WAIT

    如果MySQL出现“Host 'IP' is blocked because of many connection errors”的错误提示,表明由于过多的连接错误,该IP地址已被MySQL服务器封锁。此时,可以通过执行`mysqladmin flush-hosts -h IP -u root -p`命令...

    MYSQL

    18.2.3 Host '...' is blocked错误 18.2.4 Out of memory错误 18.2.5 Packet too large错误 18.2.6 The table is full错误 18.2.7 Commands out of sync in client错误 18.2.8 Ignoring ...

    java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to

    java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错: 解决方法: 1,登陆服务器 mysql> use mysql; //用mysql ...

    MySQL中文参考手册

    + 4.15.2 启动 MySQL 服务器的问题 + 4.15.3 自动启动和停止 MySQL + 4.15.4 选项文件 o 4.16 升级和降级(downgrading)时有什么特别要做的事情吗? + 4.16.1 从一个 3.22 版本升级到 3.23 + 4.16.2 从一个 ...

    MySQL中文参考手册.chm

    1.6 顺应2000年 1.7 SQL一般信息和教程 1.8 有用的MySQL相关链接 2 MySQL 邮件列表及如何提问或报告错误 2.1 MySQL邮件列表 2.2 提问或报告错误 2.3 怎样报告错误或问题 ...

    微软内部资料-SQL性能优化3

    Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...

    MySQL常见问题集锦详解-完整版.pdf

    4. **Host '...' is blocked**: 如果出现此错误,表示主机因多次连接错误被封锁。这可能是由于黑客攻击或其他连接问题。解锁方法是运行`mysqladmin flush-hosts`。可以通过调整`max_connect_errors`变量来设置封锁...

    MySQL-Flush命令用法.docx#资源达人分享计划#

    使用 HOSTS 选项可以清空主机名缓存,这个选项通常用于清空主机名缓存以便解决 Host 'host_name' is blocked 错误。 3. LOGS:关闭并重新加载二进制日志文件。 使用 LOGS 选项可以关闭并重新加载二进制日志文件,...

    Java常见异常

    5. **ERROR 1129 (00000): Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’** MySQL服务器将主机封锁,因为存在多次连接错误。使用`mysqladmin flush-...

    python_github_calendar_api

    若注册时提示Error:This user account is blocked.Contact support@vercel.com for more information. 这是由于Vercel不支持大部分国内邮箱。可以将github账号主邮箱改为Gmail邮箱。 但是根据群友React,将github...

    解决vue net :ERR_CONNECTION_REFUSED报错问题

    在开发Vue应用时,开发者可能会遇到“net :ERR_CONNECTION_REFUSED”错误,这通常表示浏览器无法连接到指定的服务器。这个错误可能出现在多种场景下,...希望这些信息能帮助开发者更好地理解和解决问题,提升开发效率。

    python_hopelight_calendar_api

    若注册时提示Error:This user account is blocked.Contact support@vercel.com for more information. 这是由于Vercel不支持大部分国内邮箱。可以将github账号主邮箱改为Gmail邮箱。 但是根据群友React,将github...

    Request Blocked(解决方案).md

    Request Blocked(解决方案).md

    MySQL Proxy 说明与配置

    MySQL Proxy 是一个开源工具,由MySQL AB公司开发,允许用户在MySQL服务器和客户端应用程序之间插入一个代理层。这个代理层可以用来监控、过滤、修改或者路由数据库连接的流量,为数据库管理和性能优化提供了极大的...

    一个小游戏

    Gameloft的笔试 Rules of Game: ---------... If one sphere is blocked because there is something underneath, the other one will continue falling (with no player control over it) until it reaches something.

    blocked:proc-macro,用于检查是否已解决阻止程序(问题)

    如果问题已解决,则阻止将发出包含可选“原因”的警告。 由于这需要网络访问,因此建议仅在CI构建中运行此命令,以免减慢edit-run-debug周期。 // An attribute-like procedural macro is on the todo-list#!...

    iframe跨域问题

    iframe跨域问题:Uncaught DOMException Blocked a frame with origin解决方法

    Sakemail

    Because some people need to use IP addresses instead of Host names, I‘ve added a new property IPAddress to SakPOP and SakSMTP. If both are filled, then the Host name will be used, thanks to Roger F. ...

    BURNINTEST--硬件检测工具

    Here is a summary of all changes that have been made in each version of BurnInTest. Release 5.3 build 1035 revision 4 WIN32 release 10 November 2008 - Lenovo China specific build. Lenovo system ...

Global site tag (gtag.js) - Google Analytics