Date: Mon, 13 Feb 2006 11:59:52 -0800 From: Justin Bastedo <justin.bastedo@gmail.com> To: Miroslav Lachman <000.fbsd@quip.cz> Cc: freebsd-database@freebsd.org Subject: Re: Error connecting to mysql via php Message-ID: <8a5255240602131159u295cafc4x4939a6451db9fef4@mail.gmail.com> In-Reply-To: <43F051C3.7090704@quip.cz> References: <20060212213438.O35939-100000@krynn.brundoggy.com> <43F051C3.7090704@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
One thing to check, don't think it applies to the version you are using but has caused me a similar problem in the past. Make sure your php compiled mysql client and mysql server are using the same encryption schema on the password. http://dev.mysql.com/doc/refman/5.0/en/old-client.html Another thing is what does the die display? whats the mysql Error? that might help give a bit more information. On 2/13/06, Miroslav Lachman <000.fbsd@quip.cz> 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=3D'server2'; > > $user=3D'me'; > > $passwd=3D'mypassword'; > > > > $cn =3D mysql_connect("$host", "$user", "$passwd"); > > if(!$cn) > > { > > die(mysql_error()); > > } > > > > I am assuming the reason the /tmp/mysql.sock file doesn't exist on serv= er1 > > 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 > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.or= g" > -- Justin Bastedo At Gmail Dot Com -------------------------------------------------- http://www.thebastedo.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?8a5255240602131159u295cafc4x4939a6451db9fef4>