>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