Date: Mon, 13 Feb 2006 10:30:43 +0100 From: Miroslav Lachman <000.fbsd@quip.cz> To: "S. Greg Cuff" <maillist@brundoggy.com> Cc: freebsd-database@freebsd.org Subject: Re: Error connecting to mysql via php Message-ID: <43F051C3.7090704@quip.cz> In-Reply-To: <20060212213438.O35939-100000@krynn.brundoggy.com> References: <20060212213438.O35939-100000@krynn.brundoggy.com>
index | next in thread | previous in thread | raw e-mail
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@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
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43F051C3.7090704>