Mombu the Programming Forum sponsored links

Go Back   Mombu the Programming Forum > Programming > Replace localhost Unix socket connection by Localhost TCP/IP connection
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 16th February 15:27
damien desmarets
External User
 
Posts: 1
Default Replace localhost Unix socket connection by Localhost TCP/IP connection


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 do***entation, 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_at_deviantnetwork.com.asc
  Reply With Quote


  sponsored links


2 16th February 15:27
kai ruhnau
External User
 
Posts: 1
Default Replace localhost Unix socket connection by Localhost TCP/IPconnection


That's an easy one:
localhost -> Unix socket
127.0.0.1 -> TCP socket

HTH
Kai
  Reply With Quote
3 16th February 15:27
damien desmarets
External User
 
Posts: 1
Default Replace localhost Unix socket connection by Localhost TCP/IPconnection


Kai Ruhnau a écrit :


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_at_deviantnetwork.com.asc
  Reply With Quote
4 16th February 15:27
axel schwenke
External User
 
Posts: 1
Default Replace localhost Unix socket connection by Localhost TCP/IP connection


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/
  Reply With Quote
5 16th February 15:27
jerry stuckle
External User
 
Posts: 1
Default Replace localhost Unix socket connection by Localhost TCP/IPconnection


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
==================
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666