Date: Mon, 13 Feb 2006 10:52:20 -0600 (CST) From: "S. Greg Cuff" <maillist@brundoggy.com> To: freebsd-database@freebsd.org Subject: Re: Error connecting to mysql via php Message-ID: <20060213092504.D37371-100000@krynn.brundoggy.com> In-Reply-To: <43F051C3.7090704@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
I received the same message using $host = '192.168.1.2';
or $host = '192.168.1.2:3306';
It was my understanding that only if the host is null or the string is
'localhost' then sockets would be used to connect to the database.
This seems such a drastic solution and I'm reluctant to do this but,
should I delete any packages and reinstall? If, so what is the best way
to go about this? Any preferred order?
Thanks,
Greg
On Mon, 13 Feb 2006, Miroslav Lachman wrote:
...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
...
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060213092504.D37371-100000>