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

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'

Upvotes: 8

Answers (6)

Reputation: 8906

In MySql,run the following query:

FLUSH HOSTS;

Upvotes: 3

Reputation: 7221

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

and enter your root password after that your host name will be flushed , with out showing any massage in Shell.

Upvotes: 1

Reputation: 547

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

Upvotes: 4

Reputation: 75

This must solve your issue.

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

Upvotes: 7

Reputation: 1551

Using mysqladmin you can execute this command:

mysqladmin flush-hosts;

and

mysqladmin flush-status;

This will remove the error shown by your MySQL server.

Upvotes: 1

Reputation: 782130

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'

Upvotes: 17