如何使用mysqladmin flush主机解除阻止 [英] How to unblock with mysqladmin flush hosts

问题描述

我已经经历了这里列出的类似案例，但是似乎没有用.

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;

我的错误消息如下:

无法使用用户myName

Failed to connect to MYSql at 192...* with user myName

由于连接过多，主机'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主机解除阻止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！