From owner-freebsd-questions  Thu Sep 26  6:15:36 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 EB44137B401
	for <freebsd-questions@FreeBSD.ORG>; Thu, 26 Sep 2002 06:15:34 -0700 (PDT)
Received: from mail.space2u.com (mail.space2u.com [62.20.1.135])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A4EE943E3B
	for <freebsd-questions@FreeBSD.ORG>; Thu, 26 Sep 2002 06:15:33 -0700 (PDT)
	(envelope-from div@newcode.se)
Received: from newcode.se (as5-3-5.hn.g.bonet.se [194.236.55.145])
	by mail.space2u.com (8.11.6/8.11.6) with ESMTP id g8QDJ6525252;
	Thu, 26 Sep 2002 15:19:06 +0200
Date: Thu, 26 Sep 2002 15:15:28 +0200
Subject: Re: Connecting to mysqld
Content-Type: text/plain; charset=US-ASCII; format=flowed
Mime-Version: 1.0 (Apple Message framework v546)
Cc: freebsd-questions@FreeBSD.ORG
To: Duncan Anker <d.anker@au.darkbluesea.com>
From: Carl-Johan Kihlbom <div@newcode.se>
In-Reply-To: <1033001025.31183.11.camel@duncan>
Message-Id: <06A5CE3D-D152-11D6-8506-00039363CBAA@newcode.se>
Content-Transfer-Encoding: 7bit
X-Mailer: Apple Mail (2.546)
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG


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 <div@newcode.se> 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?


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message