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

57

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

This question is tagged with mysql amazon-rds

~ Asked on 2011-11-04 18:52:07

The Best Answer is


82

For normal MySQL, just connect as the 'root' administrative super user, and issue the command:

FLUSH HOSTS

Even in the case of too many connections, MySQL should be keeping a connection in reserve so that a super user can connect.

The mysqladmin client generally connects as root anyway and issues the above SQL.

~ Answered on 2011-11-05 00:44:01


30

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

mysqladmin -h <RDS ENDPOINT URL> -P 3306 -u <USER> -p flush-hosts

you will be prompted for your password

~ Answered on 2013-03-12 17:24:02


Most Viewed Questions: