Error connecting to mysql via php

[Miroslav Lachman]

S. Greg Cuff wrote:

> Here is the ERROR:
>   Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> 
> Background:
> 
>   Two servers running FreeBSD v6.0 STABLE
> 
>   Server1: apache-2.2.0_2, php5-5.1.1, php5-mysql-5.1.1,
>            mysql-client-5.0.16
>   Server2: mysql-server-5.0.16, mysql-client-5.0.16
> 
> What I've tried:
> 
> 1. Connecting via command line works fine:
>    me at server1%  mysql -h server2 -p -u me
>    Enter password:
>    Reading table information for completion of table and column names
>    You can turn off this feature to get a quicker startup with -A
> 
>    Welcome to the MySQL monitor.  Commands end with ; or \g.
>    Your MySQL connection id is 64 to server version: 5.0.16
> 
>    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
>    mysql>quit;
> 
> 2. Connecting via php (error above):
>    $host='server2';
>    $user='me';
>    $passwd='mypassword';
> 
>    $cn = mysql_connect("$host", "$user", "$passwd");
>     if(!$cn)
>     {
>       die(mysql_error());
>     }
> 
> I am assuming the reason the /tmp/mysql.sock file doesn't exist on server1
> is because mysql is not running on this server.
> 
> Thanks in advanced,
> 
>   Greg


Try to connect with IP address instead of hostname. AFAIK 
/tmp/mysql.sock is used for localhost connections only.

Miroslav Lachman