which is kind of odd because in the process of getting
PHP4 installed, I removed and reinstalled 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.
Any ideas?
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. Take a look a www.devshed.com for an instruction on how to setup MySQL, PHP and Apache.
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
Although I didn't try it myself (no need to do so since my favorite distro doesn't install anything I don't want it to) I think you should be fine after changing the php.ini file.
Bye,
B.