Posted by Michael Vilain on 09/05/07 18:04

In article <1188981697.637517.250230@50g2000hsm.googlegroups.com>,
"C." <colin.mckinnon@gmail.com> wrote:

> On 30 Aug, 10:54, goodm...@fiduciairedefrance.com wrote:
> > Paris,
> > Le 30 08 MMVII,
> >
> > Hi,
> >
> > I have such a problem to connect to MYSQL from one server to another
> > server.
> >
>
> We have no way of telling how these servers are setup - presumably you
> are paying for hosting on them (or someone is) therefore you must have
> some support package in place - ask the hosting companies why its not
> working.
>
> Could be:
> 1) outgoing socket connections from the PHP box are blocked
> 2) incoming socket connections on the MySQL box are blocked
> 3) MySQL configured to use local connections (Unix sockets/share
> memory) only
>
> C.

That type of configuration is quite common in shared hosting
environments. You can manipulate MYSQL databases running on the local
machine where your site is running (e.g. they're on localhost) but
cannot access MYSQL over the net. From the hosting companies
perspective, it's a lot easier to deal with access to the database if
you aren't using the network.

If you need this sort of environment, you may have to get a colocated
host.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[Back to original message]