blocks|key|739023|text|对于普通超级用户，只需以‘MySQL’管理超级用户身份连接，并发出以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|739024|FLUSH+HOSTS|code-block|syntax|javascript|739025|即使在连接太多的情况下，MySQL也应该保留一个连接，以便超级用户可以连接。|739026|mysqladmin客户端通常以超级用户身份连接，并发出上述SQL命令。|offset|length|style|CODE|739027|entityMap^0|0|0|0|0|A|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For normal MySQL, just connect as the 'root' administrative super user, and issue the command:
<pre><code>FLUSH HOSTS
</code></pre>
Even in the case of too many connections, MySQL should be keeping a connection in reserve so that a super user can connect.
The <code>mysqladmin</code> client generally connects as root anyway and issues the above SQL.

blocks|key|739073|text|在Amazon+RDS上，FLUSH+HOSTS;可以从默认用户(+RDS+info中的“主用户名”)执行，这很有帮助。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|739074|entityMap^0|D|C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

On Amazon RDS <code>FLUSH HOSTS;</code> can be executed from default user ("Master Username" in RDS info), and it helps.

blocks|key|522705|text|您将必须连接您的RDS通过一台计算机，因为mysql安装在它上，我使用我的主机VPS之一使用SSH|type|unstyled|depth|inlineStyleRanges|entityRanges|data|522706|在我登录到我的VPS+(我使用putty+)之后，这很简单，我在提示符中输入了以下命令：|522707|mysqladmin+-h+[YOUR+RDS+END+POINT+URL]+-P+3306+-u+[DB+USER]+-p+flush-hosts|code-block|syntax|javascript|522708|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You will have to connect your RDS through a computer which as mysql installed on it
I used one of my hosting VPS using SSH 

After i was logged in my VPS ( i used putty ) It was simple, in the prompt i entered the following command:

<pre><code>mysqladmin -h [YOUR RDS END POINT URL] -P 3306 -u [DB USER] -p flush-hosts
</code></pre>

blocks|key|739191|text|我通过从AWS管理控制台重新启动RDS实例修复了此错误。HTH|type|unstyled|depth|inlineStyleRanges|entityRanges|data|739192|编辑:+lol向下投票|739193|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I fixed this error on my RDS instance by rebooting it from the AWS management console. HTH

[edit: lol downvotes]

blocks|key|739240|text|登录到您有权访问有问题的EC2实例并安装并运行mysqladmin的任何其他RDS实例|type|unstyled|depth|inlineStyleRanges|entityRanges|data|739241|mysqladmin+-h+<RDS+ENDPOINT+URL>+-P+3306+-u+<USER>+-p+flush-hosts|code-block|syntax|javascript|739242|系统将提示您输入密码|739243|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Login to any other EC2 instance you have that has access to the RDS instance in question and has mysqladmin installed and run

<pre><code>mysqladmin -h &lt;RDS ENDPOINT URL&gt; -P 3306 -u &lt;USER&gt; -p flush-hosts
</code></pre>

you will be prompted for your password

blocks|key|522825|text|因为主机被阻止了。尝试从其他主机连接并执行mysqladmin+flush-hosts命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|522826|mysqladmin+-h+<RDS+ENDPOINT+URL>+-P+<PORT>+-u+<USER>+-p+flush-hosts|code-block|syntax|javascript|522827|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Since the hosts is blocked. try connect it from other host and execute the mysqladmin flush-hosts command.

<pre><code>mysqladmin -h &lt;RDS ENDPOINT URL&gt; -P &lt;PORT&gt; -u &lt;USER&gt; -p flush-hosts
</code></pre>

blocks|key|522863|text|您可以在RDS+Admin上重新启动数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|522864|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can restart the database on RDS Admin.

blocks|key|522945|text|您可以使用以下命令刷新主机本地MySQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|522946|mysqladmin+-u+[username]+-p+flush-hosts
****+[MySQL+password]|code-block|syntax|javascript|522947|或|522948|mysqladmin+flush-hosts+-u+[username]+-p
****+[MySQL+password]|522949|虽然Amazon+RDS数据库服务器在网络上，但可以像使用flush+network+MySQL服务器一样使用以下命令：|522950|mysqladmin+-h+<RDS+ENDPOINT+URL>+-P+<PORT>+-u+<USER>+-p+flush-hosts
mysqladmin+-h+[YOUR+RDS+END+POINT+URL]+-P+3306+-u+[DB+USER]+-p+flush-hosts+|522951|在其他建议中，您可以通过编辑my.ini+fileMysql配置文件永久地解决多连接阻塞的错误问题|522952|改变变量max_connections+=+10000；|522953|522954|使用命令行登录到MySQL+-|522955|mysql+-u+[username]+-p
****+[MySQL+password]|522956|将以下命令放入MySQL窗口|522957|SET+GLOBAL+max_connect_errors=10000;
set+global+max_connections+=+200;|522958|使用以下命令检查可验证性-|522959|show+variables+like+"max_connections";
show+variables+like+"max_connect_errors";|522960|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|19|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1A|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1B|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|H|5|6|7|1F|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1G|8|@]|9|@]|A|$]]|$1|V|3|W|5|D|7|1H|8|@]|9|@]|A|$E|F]]|$1|X|3|Y|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Z|3|10|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|11|3|12|5|6|7|1K|8|@]|9|@]|A|$]]|$1|13|3|14|5|D|7|1L|8|@]|9|@]|A|$E|F]]|$1|15|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|16|$]]

You can flush hosts local MySQL using following command:

<pre><code>mysqladmin -u [username] -p flush-hosts
**** [MySQL password]
</code></pre>

or

<pre><code>mysqladmin flush-hosts -u [username] -p
**** [MySQL password]
</code></pre>

Though Amazon RDS database server is on network then use the following command as like as flush network MySQL server:

<pre><code>mysqladmin -h &lt;RDS ENDPOINT URL&gt; -P &lt;PORT&gt; -u &lt;USER&gt; -p flush-hosts
mysqladmin -h [YOUR RDS END POINT URL] -P 3306 -u [DB USER] -p flush-hosts 
</code></pre>

In additional suggestion 
you can permanently solve blocked of many connections error problem by editing 
my.ini file[Mysql configuration file]

change variables max_connections = 10000;

or 

login into MySQL using command line -

<pre><code>mysql -u [username] -p
**** [MySQL password]
</code></pre>

put the below command into MySQL window 

<pre><code>SET GLOBAL max_connect_errors=10000;
set global max_connections = 200;
</code></pre>

check veritable using command- 

<pre><code>show variables like "max_connections";
show variables like "max_connect_errors";
</code></pre>

blocks|key|523017|text|今天在一个使用Heidi+Sql客户端的客户rds上得到了这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|523018|我们只需在ec2上使用'mysqlroot‘来与相关rds进行连接，然后发出'flush+hosts;’命令。|523019|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

got this error today on a customer rds while they were using Heidi Sql client.
We simply used 'mysqlroot' on the ec2 that talks to the rds in question to connect, followed by issuing the 'flush hosts;' cmd.

I got a database server failure, says host is blocked because of many connection errors. It ask me to unblock with 'mysqladmin flush-hosts'

how and where should I run this command to our amazon rds database server?

thank you

how to run command "mysqladmin flush-hosts" on Amazon RDS database Server instance?

数据库

服务器

MySQL

我收到一个数据库服务器故障，说主机由于许多连接错误而被阻塞。它要求我使用'mysqladmin flush-hosts‘解除阻塞我应该如何以及在哪里对我们的amazon rds数据库服务器运行此命令？谢谢

问如何在Amazon RDS数据库服务器实例上运行命令"mysqladmin flush-hosts“？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Amazon RDS数据库服务器实例上运行命令"mysqladmin flush-hosts“？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Amazon RDS数据库服务器实例上运行命令"mysqladmin flush-hosts“？
EN