List:MySQL and PHP« Previous MessageNext Message »
From:gwahir hotmail Date:December 3 2009 5:41pm
Subject:RE: connect error
View as plain text  
thanks nil, 

 

but if i connect remotely to this mysql (from another host) i can connect.

 

 

i can't only connect via tcp from this machine to himself, or to other mysql

 


 
> Date: Thu, 3 Dec 2009 18:38:20 +0100
> From: nils@stripped
> To: gwahir@stripped; php@stripped
> Subject: Re: connect error
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
> 
> Hey gwahir,
> 
> gwahir hotmail wrote:
> > localhost and 192.168.0.1 are the same machine
> 
> Can you check the my.cnf? Check for the words: bind-address or
> skip-networking.
> 
> MySQL always listens on a unix domain socket (a special file that works
> like a tcp socket, only faster), if you connect to localhost that socket
> file is used. If you connect to the IP it uses TCP, MySQL might not
> actually be listening on any TCP ports (skip-networking) or only on the
> local TCP ports (bind-address).
> 
> regards
> Nils
> 
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.9 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iEYEAREIAAYFAksX94wACgkQ4eO3kLtdRQbefACgh4/4UChv6S7mOKmqZAeSmbbD
> vGwAoJOntEUQFo42seivzQfo2zI10qpa
> =WMCW
> -----END PGP SIGNATURE-----
 		 	   		  
_________________________________________________________________
Sólo hay un loro experto en Windows 7 en todo el mundo. Y vive en Sietes
¡Cónocelo!
http://www.sietesunpueblodeexpertos.com/
Thread
connect errorgwahir hotmail3 Dec
  • Re: connect errorNils Meyer3 Dec
    • RE: connect errorgwahir hotmail3 Dec
  • Re: connect errorMichel Belleau3 Dec
    • RE: connect errorgwahir hotmail4 Dec
      • RE: connect errorMichel Belleau4 Dec