Labels

Android (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (1) Dreamweaver (2) Eclipse (3) fail2ban (4) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (30) javascript (3) Linux (164) Mac (19) Machine Learning (1) mySQL (47) Netbeans (4) Networking (1) Nexus (1) OpenVMS (6) Oracle (1) Pandas (3) php (16) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (45) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Tuesday 27 February 2024

MySQL flush-hosts and ERROR 1129 (HY000)

Often we see an error such as:

ERROR 1129 (HY000): Host 'nn.nn.nn.nn' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

 

Any issue I've come across is where the database instance is bound to the ip address that is blocked and while there may be other ways around this, Ive had to resort to running the below command from another host;

mysqladmin --host=nn.nn.nn.nn -port=3306 -u username -p flush-hosts

where the ip address is of course the host.

It should be noted that there were no errors in the mysql log relating to the above.


No comments:

Post a Comment

Note: only a member of this blog may post a comment.