elhelaly1999 Posted November 19, 2008 Share Posted November 19, 2008 Hi MySQL version : 5 Error : Host '((MY IP))' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' description : So I execute mysqladmin flush-hosts and the problem solved But I want to know what the reason of this problem to avoid it . Link to comment Share on other sites More sharing options...
Zane Posted November 19, 2008 Share Posted November 19, 2008 Who, what, when, where, why and how. The key things. Minus the who of course since we know it's you, but What caused this error? Why do you need so many concurrent connections? When did this occur? was it random. Did you just upgrade to mysql 5 or something How did you solve this and not know where the problem came from? Link to comment Share on other sites More sharing options...
elhelaly1999 Posted November 19, 2008 Author Share Posted November 19, 2008 I will answer what,when but why and how I think I write this topic to know why and how this problem occurred last night and I didn't add anything to my site I leave my site working well and go to bed when I wake up I found this problem I will try to give you summarized explanation a bout my site First its a Drupal CMS it contain courses and students log in first to see their courses but the thing I feel that it caused this problem I didn't use Drupal database and use another database with a connection I made it and all courses information depends on my connection but the site working until now for 2 months well I hope I can give you a well explanation Sorry for length Link to comment Share on other sites More sharing options...
Mchl Posted November 19, 2008 Share Posted November 19, 2008 Host '((MY IP))' is blocked because of many connection errors. I think you shoold review your logs to see what's causing these connection errors. Link to comment Share on other sites More sharing options...
elhelaly1999 Posted November 19, 2008 Author Share Posted November 19, 2008 Thanx for reply but I don't know what I can know from logs Link to comment Share on other sites More sharing options...
Mchl Posted November 19, 2008 Share Posted November 19, 2008 By reviewing your cgi logs, you should be able to see what script is trying to connect to server, and what errors does it encounter. Link to comment Share on other sites More sharing options...
elhelaly1999 Posted November 19, 2008 Author Share Posted November 19, 2008 are you mean the apache log or there are another log ? Link to comment Share on other sites More sharing options...
Mchl Posted November 19, 2008 Share Posted November 19, 2008 The one, where your php errors are logged into (provided that you have such logging enabled, which might not be the case) Link to comment Share on other sites More sharing options...
elhelaly1999 Posted November 19, 2008 Author Share Posted November 19, 2008 ok thank you very much Mchl Link to comment Share on other sites More sharing options...
Recommended Posts