From owner-freebsd-questions Thu Sep 26 6:25: 2 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7FE3537B401 for ; Thu, 26 Sep 2002 06:25:01 -0700 (PDT) Received: from pressure.noc.uk.easynet.net (pressure.noc.uk.easynet.net [195.40.7.165]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8375C43E42 for ; Thu, 26 Sep 2002 06:25:00 -0700 (PDT) (envelope-from marc.silver@uk.easynet.net) Received: by pressure.noc.uk.easynet.net (Postfix, from userid 1332) id 135116C801; Thu, 26 Sep 2002 14:24:58 +0100 (BST) Date: Thu, 26 Sep 2002 14:24:58 +0100 From: Marc Silver To: Carl-Johan Kihlbom Cc: Duncan Anker , freebsd-questions@FreeBSD.ORG Subject: Re: Connecting to mysqld Message-ID: <20020926132458.GH13753@uk.easynet.net> References: <1033001025.31183.11.camel@duncan> <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se> User-Agent: Mutt/1.4i Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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