From owner-freebsd-questions Thu Sep 26 6:24: 3 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 17EF037B401 for ; Thu, 26 Sep 2002 06:24:02 -0700 (PDT) Received: from mail.thundernet.cz (mail.thundernet.cz [62.77.87.114]) by mx1.FreeBSD.org (Postfix) with SMTP id 7C30143E42 for ; Thu, 26 Sep 2002 06:24:00 -0700 (PDT) (envelope-from neuhauser@bellavista.cz) Received: (qmail 15454 invoked from network); 26 Sep 2002 13:23:21 -0000 Received: from unknown (HELO freepuppy.bellavista.cz) (62.168.44.50) by mail.thundernet.cz with SMTP; 26 Sep 2002 13:23:21 -0000 Received: by freepuppy.bellavista.cz (Postfix, from userid 1001) id 762DF2FDAB2; Thu, 26 Sep 2002 15:23:11 +0200 (CEST) Date: Thu, 26 Sep 2002 15:23:11 +0200 From: Roman Neuhauser To: Carl-Johan Kihlbom Cc: Duncan Anker , freebsd-questions@FreeBSD.ORG Subject: Re: Connecting to mysqld Message-ID: <20020926132311.GK30361@freepuppy.bellavista.cz> Mail-Followup-To: Carl-Johan Kihlbom , Duncan Anker , freebsd-questions@FreeBSD.ORG 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.5.1i 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 # div@newcode.se / 2002-09-26 15:15:28 +0200: > On torsdag, sep 26, 2002, at 02:43 Europe/Stockholm, Duncan Anker wrote: > >On Thu, 2002-09-26 at 07:06, Kirk Strauser wrote: > >>At 2002-09-25T20:49:20Z, Carl-Johan Kihlbom writes: > >>>I created the users with "GRANT ALL ON *.* TO kihlbom IDENTIFIED BY > >>>'password';". The users show up fine in the mysql.user table. > >> > >>Did you "FLUSH PRIVILEGES" after the addition? > > > >You don't need to do this if you use GRANT to set privileges. > > > >What else do you have set in your User table? What about the Db and > >Host tables? > > 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? you already did, and your question reveals that you didn't bother reading the mysql manual. -- begin 666 nonexistent.vbs FreeBSD 4.7-RC 3:22PM up 8 days, 22:36, 17 users, load averages: 0.25, 0.17, 0.10 end To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message