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

mysql database phpmyadmin database-connection flush
Suman KC picture Suman KC · Feb 3, 2014 · Viewed 42.5k times · Source

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'

Answer

Barmar picture Barmar · Feb 3, 2014

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'

Related questions

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying: You probably tried to upload too large file. …

Read More
Update query PHP MySQL

Can anybody help me understand why this update query isn't updating the fields in my database? I have this in my php page to retrieve the current values from the database: <?php $query = mysql_query ("SELECT * FROM blogEntry WHERE …

Read More