今天使用idea连接mysql的时候报错误:
ERROR 1129 (00000): #HY000Host ‘*192.168*.109*.3*’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
解决办法:
使用mysqladmin flush-hosts命令清除缓存,命令执行方法如下:
mysqladmin -u root -p flush-hosts
接着输入root账号密码即可.
2、然后重启mysql.
service mysqld restart