Jump to content

MySQL Blocked


Recommended Posts

Hello

 

I'm getting this message

 

Link to database cannot be established: SQLSTATE[HY000] [1129] Host 'ip address' 
 
is blocked because of many connection errors; 
 
unblock with 'mysqladmin flush-hosts'
 
I have no idea how to run the unblock statement on a hosted MySQL
 
Thanks for your help.
Edited by markjl (see edit history)
Link to comment
Share on other sites

mysqladmin is a little helper utility program you'll find it on your MySQL server.

"flush-hosts" is one of the things it can do. 

 

You have to type that command from a shell prompt.

You can run this query in browser too - in software like phpMyAdmin.

Log in to phpmyadmin and open "SQL" tab where you can run own queries.


the SQL statement you're looking for is simply this:



FLUSH HOSTS;


Link to comment
Share on other sites

×
×
  • Create New...