LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql_connect(): Lost connection (https://www.linuxquestions.org/questions/linux-software-2/mysql_connect-lost-connection-510635/)

neocookie 12-15-2006 04:26 AM

mysql_connect(): Lost connection
 
I'm having a problem connecting one server to another server's mysql installation.

We have servers 1, 2, 3, and 4. 1 contains a database which we've migrated over to 2. Server 2 is already serving database connections for servers 3 and 4, with no issues.

However, when we try and connect via PHP from server 1 to server 2's database (using port 3306) the connection fails with the following:

mysql_connect(): Lost connection to MySQL server during query

Ports are open on both server 1 and server 2, and connecting via telnet is successful.

MySQL is listening on 0.0.0.0:3306, and `netstat -apn` shows connections established for servers 3 and 4.

The my.cnf file is set up with a high level of user connections, a good amount of RAM allocation for various caches, and timeouts are as default.

Can anyone suggest a reason as to why this might be happening, or some way to track down what the problem might be?


All times are GMT -5. The time now is 05:47 PM.