相关IP:
db1: 192.168.153.135
db2:192.168.153.132
场景说明:
在db1上访问db2,使用以下语句:
mysql -uadmin -p123456 -h192.168.153.132
执行后错如下:
ERROR 1129 (HY000): Host '192.168.153.135' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
解决方法:
在db2上执行,'mysqladmin flush-hosts' 即可