PHP5-MySQL Not Connecting Through Socket
| From: | Evan J | Date: | Tue, 30 Aug 2005 12:56:54 +0000 |
| Subject: | PHP5-MySQL Not Connecting Through Socket | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40174@lists.php.net to get a copy of this message | ||
Hi,
I am running PHP 5.0.4 and MySQL 4.1.3a. (+Apache 2.0.54) When I run a
PHP script that attempts to connect to MySQL I get the following
error:
Database ERROR:Can't connect to local MySQL server through socket
'/usr/local/mysql/tmp/mysql.sock' (13)
I have placed my socket file on such location when I was configuring
MySQL and PHP was compiled with
--with-mysql-sock=/usr/local/mysql/tmp/mysql.sock (and even with
/usr/local/mysql/tmp). I even edited my php.ini
(/usr/local/php/lib/php.ini, I have installed PHP with
--prefix=/usr/local/php) and modified variable:
mysql.default_socket = "/usr/local/mysql/tmp/mysql.sock"
It still refuses to connect through the socket! I have also run a
simple mysql_connect() script to see if the intended script was the
culprit but again, it could not connect to MySQL.
phpinfo() indicates the following:
MYSQL_SOCKET /usr/local/mysql/tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include/mysql
MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient
And for directives:
mysql.default_port no value no value
mysql.default_socket /usr/local/mysql/tmp/mysql.sock /usr/local/mysql/tmp/mysql.sock
That being said, I "CAN" connect to the database via "127.0.0.1"
through TCP/IP but not through Unix Socket file. The permissions on
mysql.sock is:
ls -la /usr/local/mysql/tmp/
total 0
drwxrwx--- 2 mysql mysql 80 2005-08-24 22:09 ./
drwxr-xr-x 13 root mysql 328 2005-08-22 20:03 ../
srwxrwxrwx 1 mysql mysql 0 2005-08-24 22:09 mysql.sock=
Again, I can connect to DB through other programs (non-php) or via
commandline and even TCP but not through Unix socket file!!
Any ideas?