Thanks for all the suggestions.
Monty was right (of course). Remote connections are now working.
Thanks again,
Simon.
----- Original Message -----
From: Michael Widenius <monty@stripped>
To: Simon Sadler <simon@stripped>
Cc: <myodbc@stripped>
Sent: 30 June 1999 7:08 pm
Subject: Hostname on a Shared Server??
> >>>>> "Simon" == Simon Sadler
> <simon@stripped>
writes:
>
> Simon> Hi everyone,
> Simon> We have a some shared web space with Superb Internet (they're
excellent
> Simon> BTW). PHP and mySQL are working fine. I can also connect to mySQL
through
> Simon> Telnet.
>
> Simon> We're having trouble accessing our mySQL tables via ODBC in Access
(Win NT).
> Simon> The problem is that I don't know what to use as a host name in the
ODBC
> Simon> settings. The mySQL host name I use to connect in PHP is
"localhost" but,
> Simon> obviously, I can't just use that. I've tried the domain of our
server but
> Simon> that didn't work either. I normally get an error saying that it
can't find
> Simon> mySQL at that hostname but, strangely, I just got this:
>
> Simon> **
> Simon> "Access denied for user: 'simon@stripped' (Using
password:
> Simon> YES)(#1045)"
> Simon> **
>
> Simon> Does that mean it found the server?
>
> Yes. Now you only have to get MySQL configured to give
> user=simon,
> host=usera801.uk.uudial.com
>
> access rights.
>
>
> Simon> I have no idea how that
> Simon> "usera801.uk.uudial.com" got in there. It must be getting it from
my dial-up
> Simon> connection. I would expect that text to be the hostname I had
entered.
>
> No. The hostname you entered is the host you try to access. The
> above host is your current machine (from which you try to access MySQL)
>
> Regards,
> Monty
>
