Bug #19708 cannot connect to mysql server
Submitted: 11 May 2006 7:22 Modified: 11 Jun 2006 9:13
Reporter: fang liu Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.x OS:Windows (windows)
Assigned to: CPU Architecture:Any

[11 May 2006 7:22] fang liu
I have a group of process connecting to mysql server concurrently. I know there is a parameter, which mysql used to control the max client connection, named max_connections listed in my.cnf. But the client including both my process and mysql console cannot connect to mysql server even though I restart mysql server after overmuch connections connected. Once I met this problem, I restart the mysql server and mysql server can be started but cannot be connected again and won't stop properly further. The only way is to restart the computer to solve this problem. I have to control mysql connections within a reasonable value, otherwise mysql make this fault. Meanwhile there is no error shown in *.err file in mysql\data directory.

How to repeat:
Just create a program connect to mysql and hold the connection. Then create process of this program one by one till the new process cannot connect to mysql server. Then you may stop the running process or directly stop mysql server (and restart it), both of them cause that you cannot connect to mysql server.
[11 May 2006 9:13] MySQL Verification Team
Hi Fang, from your description is sounds like you need to tweak the TCP parameters.  Please do that, after reading: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html
[11 Jun 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".