mysql blocking other servers after a while

D

dotdoms

Verified User
Joined
Oct 28, 2006
Messages
45
Hi there,

I got a mysql database on my DA - server that I need to access from several other servers in quite fast frequency (so I did allow access from % in DA) but now all of a sudden my scripts give me that error:

Warning: mysql_connect(): Host 'xyz' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in /home/users/script.php on line 8
Click to expand...

Now I manually unblocked again these hosts my flush-hosts... but what I wonder is how I can turn off that feature on the DA-server that hosts the mysql database?
 
Its not a da feature its a mysql feature check google.
 
ic, thx for the info... do you probably know how I would turn that off in mysql?
 
found it... for others with the same problem: you can set max_connect_errors to higher values in my.cnf and then restart mysql...
 
You must log in or register to reply here.
Back
Top