From owner-freebsd-questions@FreeBSD.ORG  Sun Jun 22 19:31:20 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 84E3437B401
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 19:31:20 -0700 (PDT)
Received: from web40612.mail.yahoo.com (web40612.mail.yahoo.com
	[66.218.78.149])	by mx1.FreeBSD.org (Postfix) with SMTP id 12CC943FE0
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 19:31:20 -0700 (PDT)
	(envelope-from pjn0211@yahoo.com)
Message-ID: <20030623023119.82609.qmail@web40612.mail.yahoo.com>
Received: from [202.183.248.166] by web40612.mail.yahoo.com via HTTP;
	Mon, 23 Jun 2003 03:31:19 BST
Date: Mon, 23 Jun 2003 03:31:19 +0100 (BST)
From: =?iso-8859-1?q?Supote=20Leelasupphakorn?= <pjn0211@yahoo.com>
To: freebsd-questions@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
cc: fallenbr@uol.com.br
Subject: Re: Granting access on MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 23 Jun 2003 02:31:20 -0000

> Hello,

> I need to grant a user access to a database. How can
I do it?

> This is what I've tried:

> mysql> grant all on databasename.* to username;

> I got no error messages, but I after connecting as >
the user, I couldn't use the database.

Hi,
  Finally, don't forget to "flush privileges" or
restart
your mysql daemon after you granted permissions.

Cheer,


________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/