SEO

#1 (**permalink**) 02-28-2008, 08:13 AM

Hi
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.

I'm sure i'm not the first to do this but i haven't found the response
on the mysql documentation, google and newsgroups.

Thanks

--

Damien Desmarets 1 place Paul Verlaine
Directeur Technique 92100 Boulogne-Billancourt - France
Deviant Network Tel. : 0 871 100 200
http://www.deviantnetwork.com Fax : 0 871 100 201

GPG : http://www.deviantnetwork.com/damien...etwork.com.asc

#2 (**permalink**) 02-28-2008, 08:13 AM

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

#3 (**permalink**) 02-28-2008, 08:13 AM

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).

--

Damien Desmarets 1 place Paul Verlaine
Directeur Technique 92100 Boulogne-Billancourt - France
Deviant Network Tel. : 0 871 100 200
http://www.deviantnetwork.com Fax : 0 871 100 201

GPG : http://www.deviantnetwork.com/damien...etwork.com.asc

#4 (**permalink**) 02-28-2008, 08:13 AM

Damien Desmarets <damienNOSPAMPLEASE@deviantnetwork.com> wrote:
> Kai Ruhnau a écrit :
>>
>> localhost -> Unix socket
>> 127.0.0.1 -> TCP socket
>>
> 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).

That's not possible AFAIK. The "localhost -> socket" rule is hardcoded
in the MySQL client library. You can start mysqld with --skip-socket
to have it not listening on a UNIX socket. But then all your localhost
clients will fail to connect.

XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

#5 (**permalink**) 02-28-2008, 08:13 AM

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
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Replace localhost Unix socket connection by Localhost TCP/IP connection