问题描述
我已经经历了这里列出的类似案例，但是似乎没有用.
I have gone through similar cases listed here but it doesn't seem to work.
我正在使用MySQL Workbench与托管在另一台服务器上的数据库建立连接.尝试了几次，无法连接，然后出现此错误.我对我应该在哪里冲洗感到困惑.在PhpMyadmin下的SQL查询? Cos当我尝试输入以下命令时，它作为语法错误返回.我使用的是Windows操作系统，因此也没有外壳脚本可以让我输入此信息.我现在正在通过Cpanel/phpmyadmin临时访问数据库.
I was using MySQL Workbench to establish a connection with my database which is hosted on another server. Tried a few times and unable to connect followed by this error. I am confused as to where I should even do this flush. On PhpMyadmin under the SQL query? Cos when I tried to input the following command, it returns as syntax error. I am using a windows OS thus no shell shell scripting for me to input this information either. I am accessing the database temporarily via Cpanel/ phpmyadmin now.
请帮助告诉我应该在哪里输入此数据以及我的语法是否错误.感谢帮助.
Please help to tell where I should input this data and if my syntax is wrong. Thanks for help.
mysqladmin flush-hosts;
or
mysqladmin -umyname -pmypassword flush-hosts;
我的错误消息如下:
由于连接过多，主机'host-92...*.as13285.net'被阻止 错误；使用"mysqladmin flush-hosts"取消阻止
Host 'host-92...*.as13285.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
推荐答案
mysqladmin不是SQL语句.它是一个小助手实用程序，您可以在MySQL服务器上找到...，刷新主机"是它可以做的事情之一. (状态"和关闭"是另外两件事.
mysqladmin is not a SQL statement. It's a little helper utility program you'll find on your MySQL server... and "flush-hosts" is one of the things it can do. ("status" and "shutdown" are a couple of other things that come to mind).
您从shell提示符下键入该命令.
You type that command from a shell prompt.
或者，从查询浏览器(例如phpMyAdmin)中，您要查找的SQL语句很简单:
Alternately, from your query browser (such as phpMyAdmin), the SQL statement you're looking for is simply this:
FLUSH HOSTS;
http://dev.mysql.com/doc/refman/5.6/en/flush .html
http://dev.mysql.com/doc/refman/5.6/en/mysqladmin .html
这篇关于如何使用mysqladmin flush主机解除阻止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！