Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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'
like image 782
Suman KC Avatar asked Feb 03 '14 05:02

Suman KC


2 Answers

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'
like image 97
Barmar Avatar answered Oct 28 '22 14:10

Barmar


This must solve your issue.

mysql -u root -p -e 'flush hosts'
like image 7
user3418943 Avatar answered Oct 28 '22 13:10

user3418943