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?
This question is tagged with
~ Asked on 2011-11-04 18:52:07
For normal MySQL, just connect as the 'root' administrative super user, and issue the command:
Even in the case of too many connections, MySQL should be keeping a connection in reserve so that a super user can connect.
mysqladmin client generally connects as root anyway and issues the above SQL.
~ Answered on 2011-11-05 00:44:01
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