Re: php cli and mysql

Tom Ray [Lists] wrote:

Roman Neuhauser wrote:

# cajbecu@gmail.com / 2006-11-14 20:17:16 +0200:

On 11/14/06, James Tu <jtu@esidesign.com> wrote:

I'm running a php script from the command line (I'm on OS X) and I'm getting ... Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

touch /var/mysql/mysql.sock chmod 777 /var/mysql/mysql.sock

How could that possibly help?

Because if the mysql.sock file is missing the mysql server won't start. If the mysql server isn't running the PHP script won't work. So I think it helps a lot.

Actually the opposite - it becomes a lot harder to debug/diagnose. PHP uses the socket file to talk to mysql if you connect to 'localhost' rather than using a tcp/ip connection. If the socket file is invalid (as this would be), then mysql_connect fails, mysql_query fails and so on. The problem as it turns out was that php was looking in the wrong place, if this file was there and empty, then you'd get completely different errors which would make it harder to find the original problem. -- Postgresql & php tutorials http://www.designmagick.com/