MySQL blocking new connections, and mysqladmin flush-hosts
- by aidan
I'm running MySQL on a remote server, and it suddenly started rejecting all connections:
$ mysql -h 192.168.1.10 -u root -p
ERROR 1129 (00000): Host 'web' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
So, I try this flush-hosts command...
$ mysqladmin flush-hosts -h 192.168.1.10 -u root -p
mysqladmin: connect to server at '192.168.1.10' failed
error: 'Host 'web' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts''
I.e. it's blocking the very un-blocking tool it recommends. Am I doing it wrong, or will I have to resort to ssh/cpanel/physical access?