MySQL 如何在服务器上执行“mysqladmin flush-hosts”？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21519997/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to do "mysqladmin flush-hosts" on server?
提问by Suman K.C
I have a hosting account, on database section i have "MySQL? Databases", "MySQL? Database Wizard","phpMyAdmin" and "Remote MySQL" Options
我有一个托管帐户，在数据库部分我有“MySQL？数据库”、“MySQL？数据库向导”、“phpMyAdmin”和“远程 MySQL”选项
Error i am getting is
我得到的错误是
Database ErrorHost 'adonis.havehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
回答by Barmar
Write a server application that sends the query:
编写一个发送查询的服务器应用程序：
FLUSH HOSTS
to MySQL.
到 MySQL。
If you have shell access to the server, you can login and do:
如果您对服务器具有 shell 访问权限，则可以登录并执行以下操作：
mysql -u root -p -e 'flush hosts'
回答by user3418943
This must solve your issue.
这必须解决您的问题。
mysql -u root -p -e 'flush hosts'
回答by Uchit Shrestha
mysql -u root -p -e 'flush hosts' And you can even contract your server provider
mysql -u root -p -e 'flush hosts' 你甚至可以和你的服务器提供商签约
回答by Shiv Singh
log in to your server by putty SSH, and just type this command
通过 putty SSH 登录到您的服务器，然后键入此命令
mysql -u root -p -e 'flush hosts'
mysql -u root -p -e 'flush hosts'
and enter your root password after that your host name will be flushed , with out showing any massage in Shell.
并输入您的 root 密码，然后您的主机名将被刷新，而不会在 Shell 中显示任何信息。
回答by Ayan
In MySql,run the following query:
在 MySql 中，运行以下查询：
FLUSH HOSTS;
回答by Mahesh Patil
Using mysqladminyou can execute this command:
使用mysqladmin您可以执行以下命令：
mysqladmin flush-hosts;
mysqladmin 刷新主机；
and
和
mysqladmin flush-status;
mysqladmin 刷新状态；
This will remove the error shown by your MySQL server.
这将消除您的 MySQL 服务器显示的错误。
