Date: Thu, 26 Sep 2002 14:24:58 +0100 From: Marc Silver <marc.silver@uk.easynet.net> To: Carl-Johan Kihlbom <div@newcode.se> Cc: Duncan Anker <d.anker@au.darkbluesea.com>, freebsd-questions@FreeBSD.ORG Subject: Re: Connecting to mysqld Message-ID: <20020926132458.GH13753@uk.easynet.net> In-Reply-To: <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se> References: <1033001025.31183.11.camel@duncan> <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se>
next in thread | previous in thread | raw e-mail | index | archive | help
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 majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020926132458.GH13753>