MySQL - Host is blocked because

2020-01-22  本文已影响0人  nzdxwl

在运行seata示例时碰到这个问题,具体如何发生原因暂不清楚:

Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

网上搜索了一下找到了解决方法,也记录一下:
打开命令行,进入MySQL安装目录的bin文件夹下执行以下命令:
mysqladmin -u[username] -p flush-hosts
执行后输入用户密码,正常执行后可以解决问题。

相关概念:

mysqladmin

Client for Administering a MySQL Server
管理MySQL服务器的客户端工具

Host Cache

The MySQL server maintains a host cache in memory that contains information about clients: IP address, host name, and error information. The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. This may help you diagnose the causes of connection problems.

MySQL服务器会在内存中维护一个关于客户端信息的主机缓存,包括客户端ip、客户主机名称以及错误信息,在Performance Schema的host_cache表中可以查看相关信息。
select * from performance_schema.host_cache

FLUSH Statement

FlUSH HOST 是FLUSH的功能之一,用于清空主机缓存和主机缓存表,并且解除对已阻塞主机的拦截
Empties the host cache and the Performance Schema host_cache table that exposes the cache contents, and unblocks any blocked hosts.

上一篇下一篇

猜你喜欢

热点阅读