On Fri, Sep 23, 2005 at 08:07:54PM +0200, Olaf van der Spek wrote: > On 9/23/05, Christoph Haas <[EMAIL PROTECTED]> wrote: > > 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.
http://dev.mysql.com/doc/mysql/en/connection-access.html reads: ---------------snip----------------- # A Host value may be a hostname or an IP number, or 'localhost' to indicate the local host. # You can use the wildcard characters ‘%’ and ‘_’ in Host column values. These have the same meaning as for pattern-matching operations performed with the LIKE operator. For example, a Host value of '%' matches any hostname, whereas a value of '%.mysql.com' matches any host in the mysql.com domain. ---------------snap----------------- So 'localhost' means the current host and '%' is a wildcard for other hosts. IIRC MySQL will not accept '%' if I connect from the same machine (unless I explicitly connect to an IP on an interface other than 'lo'). And I still wonder where .localdomain comes from. :) Christoph -- ~ ~ ~ ".signature" [Modified] 3 lines --100%-- 3,41 All -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
