How to do "mysqladmin flush-hosts" on server?

Question

I have a hosting account, on database section i have "MySQL® Databases", "MySQL® Database Wizard","phpMyAdmin" and "Remote MySQL" Options

Error i am getting is

Database ErrorHost 'adonis.havehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Solution 1

Write a server application that sends the query:

FLUSH HOSTS

to MySQL.

If you have shell access to the server, you can login and do:

mysql -u root -p -e 'flush hosts'

Solution 2

This must solve your issue.

mysql -u root -p -e 'flush hosts'

Solution 3

mysql -u root -p -e 'flush hosts' And you can even contract your server provider

Solution 4

In MySql,run the following query:

FLUSH HOSTS;

Solution 5

Using mysqladmin you can execute this command:

mysqladmin flush-hosts;

and

mysqladmin flush-status;

This will remove the error shown by your MySQL server.

View more solutions