Jump to content


Photo

PHP Lost connection to MySQL server during query


  • Please log in to reply
No replies to this topic

#1 g0itp1

g0itp1
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 20 April 2006 - 09:00 PM

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'




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users