List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 1 1999 6:45pm
Subject:Re: User access to server from localhost?
View as plain text  
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 
>didn't work.
>  >
>  > 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
>  >
>  >
>  >
>
>Hi!
>
>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
>happily !!


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
Thread
User access to server from localhost?Ken Menken1 Nov
  • Re: User access to server from localhost?Paul DuBois1 Nov
  • Re: User access to server from localhost?sinisa1 Nov
    • Re: User access to server from localhost?Ken Menken1 Nov
      • Re: User access to server from localhost?sinisa1 Nov
      • Re: User access to server from localhost?sinisa1 Nov
        • Re: User access to server from localhost?Ken Menken1 Nov
          • Re: User access to server from localhost?Benjamin Pflugmann2 Nov
    • Re: User access to server from localhost?Paul DuBois1 Nov