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

Question

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

Answer 1

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.

Answer 2

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