Error connecting to mysql via php
S. Greg Cuff
maillist at brundoggy.com
Sun Feb 12 20:04:49 PST 2006
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 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
More information about the freebsd-database
mailing list