RE: [PHP] PHP installed - MySql Server can't connect

Maybe his mysql.sock file isn't in /var/lib/mysql/mysql.sock? Mine is /tmp/mysql.sock -----Original Message----- From: Rasmus Lerdorf [mailto:rasmus@php.net] Sent: Friday, July 13, 2001 1:31 AM To: Gaylen Fraley Cc: php-general@lists.php.net Subject: Re: [PHP] PHP installed - MySql Server can't connect This happens when the mysql server you are running is different from the version of the mysql library php was linked against. If you compiled php using "--with-mysql" you get the mysql client library that comes bundled with PHP which may not match your mysql server and thus may look for the mysql.sock file in the wrong place. To fix this, either figure out where your mysql.sock file is and specify it directly in your mysql_connect() call (see http://php.net/mysql_connect) or recompile PHP against your system's mysql client library by using "--with-mysql=/usr" assuming your mysql client library is in /usr/lib/mysqlclient.* -Rasmus > PHP install went perfectly. phpinfo shows MySql installed. But, when > I try to start Mysql, I get: > > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111) > > What and why? > > Please reply to my e-mail address if you can help. Thanks! > > -- > Gaylen > gfraley5@earthlink.net > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net