Re: Mysql socket connect problems
| From: | Paul Newby | Date: | Wed, 21 Mar 2001 02:28:18 +0000 |
| Subject: | Re: Mysql socket connect problems | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-2531@lists.php.net to get a copy of this message | ||
> >which is kind of odd because in the process of getting
> >PHP4 installed, I removed and MySQL, and changed
> >the layout in the process: the mysql directory
> >was moved from /var/lib to /usr/local/mysql/var
> >and PHP4 was configured with '--with-mysql=/usr/local/mysql'
> >... so I don't know why php appears to be referring
> >to /var/lib/mysql at all.
>
> Most installscripts will leave things like configfiles untouched. If you
> build from source you should copy the distributed INI file to a useful
> place. You probably didn't take this last step.
...
> Your old config file has the old location you could alter this manually.
> Change the location of mysql.sock and restart apache. Use Pico or your
> favorite text editor to edit your php.ini
> ...
> I think you should be fine
> after changing the php.ini file.
Yes, I wouldn't be surprised if the problem is an existing
configfile, but I don't know which one. The location
of mysql.sock isn't specified or implied in php.ini, so
far as I can see.
Configuring mysql with
--with-unix-socket-path=/usr/local/mysql/var/mysql.sock
doesn't seem to make any difference either.
Paul N.