Hi there, On Thu, Sep 26, 2002 at 03:15:28PM +0200, Carl-Johan Kihlbom wrote: > It worked when i specified the host, as in: GRANT ALL ON *.* to > kihlbom@localhost. So now the user kihlbom can connect from localhost. > But I would prefer it if that user could connect from any host. How do > I do that?
This is a bit risky from a security standpoint, but you could do this like so (for eg): grant select on dbname.* to username@"%" identified by "password"; OR grant select on dbname.* to username@"%.myisp.net" identified by "password"; Hope this helps, Marc To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message