Posted by Shelly on 10/03/30 11:37

"Steve" <ThisOne@Aint.Valid> wrote in message
news:pan.2006.01.18.08.22.51.691382@Aint.Valid...
> On Tue, 17 Jan 2006 22:24:54 -0500, Shelly wrote:
>
>> (also posted to alt.php.sql and comp.databases.mysql)
>>
>> This is an old problem. I extensively researched the postings on the
>> internet and have found no solution. So, perhaps someone here can help.
>>
>> The problem is that from my index.php file I get:
>>
>> Can't connect to local MySQL server through socket
>> '/var/lib/mysql/mysql.sock'
>>
>> Now, when I do an ls -l '/var/lib/mysql/mysql.sock it shows that the
>> daemon
>> is running. It shows it there (size 0, as it should be). Furthermore, I
>> can connect from command line and can do mysql commands. The mysql is on
>> the same machine as the web server, so I use localhost as the host. php
>> is
>> running on the server as well. The ini file shows the default location
>> of
>> be empty, so it should default to the installation default of
>> /var/lib/mysql/, and it does since it shows up with an ls.
>>
>> One post suggested changing ownership and group to mysql. I did that,
>> but
>> in reality that is how was originally anyhow.
>>
>> So, I am stumped. Are there any suggestions?
>>
>> Shelly
>
> What relevant entries do you have in php.ini? Dos it redefine the socket
> to use?
>
> There are off my test server, which works fine...
>
> Client API version 4.1.14
> MYSQL_MODULE_TYPE external
> MYSQL_SOCKET /var/run/mysqld/mysqld.sock
> MYSQL_INCLUDE -I/usr/include/mysql
> MYSQL_LIBS -L/usr/lib -lmysqlclient

There are no MYSQL entries in php.ini. There are several mysql entries, but
none of those. The mysql_default_socket is empty, which should take it to
/var/lib/mysql -- which is where I found it.

Shelly

[Back to original message]