Mysql客户端在连接服务器时出现Host ' xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts',折腾了好久,以为是本地Mysql服务的问题,卸载了重装依然无解。最后才发现原来应该更改服务器端的Mysql服务。在服务器端执行如下命令:
/usr/mysql/bin/mysqladmin flush-hosts -uroot -ppassword
问题解决
Mysql客户端在连接服务器时出现Host ' xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts',折腾了好久,以为是本地Mysql服务的问题,卸载了重装依然无解。最后才发现原来应该更改服务器端的Mysql服务。在服务器端执行如下命令:
/usr/mysql/bin/mysqladmin flush-hosts -uroot -ppassword
问题解决