mysqladmin

今天碰到一个问题： 

mysql_connect(): Host ‘xxx’ is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

然后尝试：mysqladmin flush-hosts， 报错 

Can't connect to local MySQL server through socket '/home/xxx/database/mysql/tmp/mysql.sock

原因是直接使用mysql, mysqladmin等命令时，会通过sock文件连接数据库，如果sock文件不存在，则报错。

解决办法：mysql,mysqladmin此类命令也可指定host, port, user, passsord进行连接

./mysqladmin -uroot -h127.0.0.1 -P8509 flush-hosts 如果有密码再加个 -pXXX