On 9/23/05, Christoph Haas <[EMAIL PROTECTED]> wrote: > On Fri, Sep 23, 2005 at 04:59:52PM +0200, Gabor Gombas wrote: > > On Fri, Sep 23, 2005 at 02:47:58PM +0200, Christoph Haas wrote: > > > ..warning: connect to mysql server foobar: Access denied for user > > > 'whoever'@'localhost.localdomain' (using password: YES) > > > > Well, I had seen several machines having "127.0.0.1 > > localhost.localdomain localhost" in /etc/hosts and running MySQL without > > problems, so you could be a bit more specific about how do you get this > > error. > > An example is running Postfix with MySQL lookups. > > > > because it expected to resolve 127.0.0.1 to the name "localhost". > > > > Expected by whom? > > It appears like MySQL does that. It seems to check the IP address of the > connecting client to find the permissions in it's internal `users` > table. So it sees "127.0.0.1" and looks up "localhost.localdomain" which > it cannot find since it expects "localhost".
Put % in the host field and base authentication on passwords.
