My PHP installation seems to be confused as to where to find the MySQL
The error I'm getting is: "Warning: mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
This isn't where the mysql.sock file is. It's at /tmp/mysql.sock.
This is possibly related to the fact that our MySQL installation has moved
since PHP was initially configured and that PHP is somehow still looking for
the old MySQL installation.
How can I get PHP to not get confused about which .sock file to use? Do I
need to recompile PHP?
In my searching around, the closest I've come to an explanation is at the
FAQs for PHP:
"Given the above, having multiple versions of the library can get messy. For
example, if you link mod_auth_mysql against one version and PHP against
another, and then enable both in Apache, you get a nice fat crash. Also, the
bundled library didn't always play well with the installed server version.
The most obvious symptom of this being disagreement over where to find the
mysql.socket Unix domain socket file."
But not sure what to do about this.
Thanks for any help you can offer!
PHP version 4.34.
MySQL version 4.1.1