List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 1 1999 6:04pm
Subject:Re: User access to server from localhost?
View as plain text  
>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?

Remove the entries from the user table that have blank User column
values, reload the grant tables, and try again.

-- 
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