Can someone tell me how to list the hosts which are blocked by the mysql server due to the reason that they crossed the limit of max_connect_errors. Is there any table in which MySQL server keeps this data. I am using mysql-server-5.1.63
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Noted in 5.6.5 changelog.
MySQL now provides improved access to the host cache, which contains client host name and IP address information and is used to avoid DNS lookups. These improvements have been implemented:
Improved access to host cache contents makes it possible to answer questions such as how many hosts are cached, or how close hosts are to being blocked (by checking whether the host_cache.SUM_CONNECT_ERRORS column is approaching the value of the max_connect_errors system variable).