On 9/23/05, Christoph Haas <email@example.com> 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.