Damien Desmarets wrote:
> Kai Ruhnau a écrit :
>
>>Damien Desmarets wrote:
>>
>>>I would like to know how don't use unix socket when i set the hostname
>>>of the mysql database to localhost.
>>>It seems that when you set the hostname to localhost it use by default
>>>the unix socket and not the IP translation for localhost (basicly
>>>127.0.0.1).
>>>I would use the TCP/IP connection to change the localhost IP to a remote
>>>server, with it i have not to change all the clients scripts.
>>
>>That's an easy one:
>>
>>localhost -> Unix socket
>>127.0.0.1 -> TCP socket
>>
>>HTH
>>Kai
>
> I wan't change all scripts of my clients, they use localhost for the host.
> I want mysql to stopping using unix socket for localhost and use the IP
> of localhost (changing to a remote server not 127.0.0.1).
>

Any way you go about it you're going to have to change the code in your
client's scripts. Even if you were able to change localhost to point to
another machine (which you could do in your hosts file but it won't
change MySQL's operation), you may muck up other things on the server -
localhost is supposed to always point at the local machine, and other
apps may depend on it.

You're better off placing the hostname in an include file then using it
in your code, i.e.

hostname.inc.php:
<?php
$hostname='localhost';
?>

clientpage.php:
<?php
include('hostname.inc.php');
...

$link = mysql_connect($hostname,...).
...
?>

Of course, a better way would be to encapsulate the db link in a PHP
class, but that would require more changes to the code.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================