Thread: Can't connect
View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:16 AM
Shelly
 
Posts: n/a
Default Re: Can't connect


"Brian Wakem" <no@email.com> wrote in message
news:436d43F1lc3tcU1@individual.net...
> Shelly wrote:
>
>> (also posted to alt.php.sql)
>>
>> 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?

>
>
> Login at the command line and enter 'status' and have a look at the 'UNIX
> socket:' line. I suspect it will be /tmp/mysql.sock, in which case you
> will have to tell php to use the correct socket or tell mysql to use the
> one in /var/lib/mysql


It didn't understand "status".

Shelly


Reply With Quote