Fix Host ‘IP’ is blocked because of many connection errors on MySQL/MariaDB

last updated in Categories , , , , , , ,

I am trying to login to my mysql/mysqld server using the following Unix command:
$ mysql -u foo -h 172.16.5.100 -p dbnmame
But greeted with the following error on screen:
ERROR 1129 (HY000): Host ‘172.16.5.100’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
How do I fix this problem on a Linux or Unix-like system?

MySQL: Set Cache Size

last updated in Categories

How do I set query cache under MySQL running under UNIX / Linux / BSD or Windows operating systems?