MySQL/PHP & localhost

admin

Administrator
Staff member
Hello,

Having a problem on a FreeBSD server running a PHP 4.0.2 and MySQL 3.22.25.

In my php.ini file I have the HOST defined as "localhost". When I connect to the DB and check the access logs it's showing "localhost.pair.com" (pair.com is my provider).

This is causing PHP/MySQL to use TCP to connect instead of just using Unix Sockets to connect ... this in turn is causing a problem with hung TCP connections causing the entire DB to stop responding till they clear out.

What I am looking for is: What do I need to do so that it just passes "local" host and doesn't prepent the domain of the server ".pair.com" onto the host name.

Thanks for any help

David
 
Back
Top