Error connecting to mysql via php

Hi,

I've searched and searched and am a little numb at this point.

I haven't been able to find a solution to an error I am receiving when
attempting to connect to a remote mysql server with a php script.

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@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

_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[email protected]"