At 8:11 PM +0200 11/1/99, <sinisa@stripped> wrote:
>Ken Menken writes:
> > I just noticed something odd.
> > I created myself as a user with full privs from Host '%' - any host.
> > When I set up myODBC I put in user me and password prx, and it works. I can
> > also use mysql client from another machine. However, I can NOT connect
> > @localhost, from the machine running the server. Yes, I used -u to make
> > sure I was accessing the server as myself.
> > I tried changing the Host limitation to '' (empty) and that also
> > Obviously the workaround is to put myself into the user db again with
> > Host='localhost' -- but what's the deal? Is something misconfigured or is
> > this a feature?
> > Ken
>Your problem points to misproper configuration of TCP/IP or of bad
>name resolution. Check /etc/hosts for localhost entry.
>Check whether loopback is configured in TCP/IP, and it will all work
It's more likely that the problem is the anonymous-user entries that
are installed in the grant tables by default.
Paul DuBois, paul@stripped