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

in Categories CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, Suse, Troubleshooting, UNIX last updated November 15, 2017

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

in Categories MySQL last updated April 16, 2010

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