Flush hosts using MySQL and MySQLAdmin

When you use FLUSH HOSTS, MySQL will effectively imply that its record of which hosts are currently or recently connected is reset, allowing you to connect to those hosts once more.

As seen below, you can clear the host cache from the shell prompt without entering into MySQL. And doing so will assist in automating them at predetermined intervals.


mysql –host <rds-host-name> -u username -pPassword -e “FLUSH HOSTS;”;

mysqladmin –host <rds-host-name> -u username -pPassword flush-hosts;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s