PHP Lost connection to MySQL server during query

[g0itp1]

Hi,

Please help, I getting a report on my php page "Lost connection to MySQL server during query"

I feel its the socket connection, but I'm unsure where to make the alteration:

PHpinfo reports MySqll data as:

Mysql_Socket = /tmp/mysql.sock --- this is not what is in my.cnf or as compiled

Mysql.default_socket = /var/run/mysqld/mysqld.sock - which is correct !


the questions are, 1. is the wrong socket causing the lost connection and 2 where do I change it, as I compiled PHP with the correct socket specified

any help gratefully received.............

./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql=/usr/local/mysql/' '--with-mysql-sock=/var/run/mysqld/mysqld.sock' '--prefix=/usr/local/php-4.4.2' '--with-config-file-path=/etc/init.d' '--enable-force-cgi-redirect' '--disable-cgi' '--with-zlib' '--with-gettext' '--enable-sockets'