From owner-freebsd-questions@FreeBSD.ORG  Sun Jun 22 15:46:56 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 96B4037B401
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 15:46:56 -0700 (PDT)
Received: from ginsberg.uol.com.br (ginsberg.uol.com.br [200.221.29.48])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 8C7A643FDD
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 15:46:54 -0700 (PDT)
	(envelope-from fallenbr@uol.com.br)
Received: from localhost ([200.161.253.1])
	by ginsberg.uol.com.br (8.9.1/8.9.1) with SMTP id TAA09387
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 19:46:47 -0300 (BRT)
Date: Sun, 22 Jun 2003 19:45:38 -0300
From: Konrad Scorciapino <fallenbr@uol.com.br>
To: freebsd-questions@freebsd.org
Message-Id: <20030622194538.141630d0.fallenbr@uol.com.br>
X-Mailer: Sylpheed version 0.8.10claws (GTK+ 1.2.10; i386-portbld-freebsd4.8)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Subject: 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: Sun, 22 Jun 2003 22:46:56 -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.