Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:12876 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 83934 invoked by uid 1010); 16 Sep 2004 17:23:52 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 83851 invoked by uid 1007); 16 Sep 2004 17:23:52 -0000 Message-ID: <20040916172352.83849.qmail@pb1.pair.com> To: internals@lists.php.net References: <20040916040105.25425.qmail@pb1.pair.com> <4149444A.9000503@hristov.com> Date: Thu, 16 Sep 2004 10:23:55 -0700 Lines: 37 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response X-Posted-By: 24.165.85.87 Subject: Re: [PHP-DEV] mysql_connect using version 5.0.1 accesses the internet when host and client are the same system From: SoCalSam@GMail.com ("Sam Hobbs") "Andrey Hristov" wrote in message news:4149444A.9000503@hristov.com... >> > Hi, > AFAIK MySQL on windows by default tries to use TCP/IP, this differs from > the > default behavior on *nix, where it tries to Unix socket and after that > TCP/IP. > On windows nt one can use named pipes, however they are not enabled by > default. Use --enable-named-pipe, or just --skip-networking. The latter > instructs > MySQL not to use TCP/IP. > More info here : > http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Thank you. If that is what is happening then I agree that it is not PHP issue, so I am happy to go elsewhere for help. The only relevant suggestion is that it might help to impove the warning message and to put something in the php documentation to help people know where to look. Many people are having problems with this. I have seen the "MySQL Manual | A.2.2 Can't connect to [local] MySQL server" page. It is confusing, since the title says "[local]" yet the last item on the page that says to check the firewall says "to allow external access", which I interpreted to mean not-local access. I wish I knew what the disadvantage of pipes are. That is not a php issue, though; it is something that the MySQL documentation should clarify. Probably pipes work great if there is no need to access MySQL outside of the system it is installed in. If so, then it would help for the MySQL documentation to say so explicitely. It might say that, but I have not seen it said. I know that MySQL does poll the internet very, very often and if turning off it's use of the network eliminates access to the internet then that is one less thing to be concerned about.