I think that there is an error in your code.
I have had this problem with a small application I wrote:
The problem arises when you don't send the quit command to mysql before dropping tcp.
You must send a quit command in every case (if you opened a socket).
I can not be more precise because i don't know what labguage you use (C, php, ...).
There is a command to reenable connection; if my memory is good: mysqladmin -flush-hosts or something (see mysqladmin reference or help).
Santino
At 9:02 -0700 1-09-2004, Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several versions of mysql 4.0 running on OS X (both client and server). Every once in a while we wake up to find the "too many connections" error coming up. There really aren't too many connections (we have our max set to 99) - it's the type of message that appears when a wrong password is used too many times (and I'm 100% sure this isn't happening).
Now, the problem is that once this message starts appearing we can't even connect with mysqladmin as root. That "extra connection" that mysql promises doesn't exist. The only way we can shut down mysql is to perform a 'kill -9' (then restart the server and repair all the tables).
And we can't reproduce this problem at will. This is driving us nuts.
Before I report this as a bug I wanted to know if anyone else has seen something like this or has any suggestions of how to narrow down the problem.
Thanks! Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
