From owner-freebsd-questions@FreeBSD.ORG  Sun Jun 22 19:29:51 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 8BB6037B401
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 19:29:51 -0700 (PDT)
Received: from alpsgiken.alpsgiken.gr.jp (www.alpsgiken.gr.jp
	[210.166.150.61])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5E81E43FDF
	for <freebsd-questions@freebsd.org>;
	Sun, 22 Jun 2003 19:29:50 -0700 (PDT)
	(envelope-from joel@alpsgiken.alpsgiken.gr.jp)
Received: from zz_radiant2 (www1.alpsgiken.gr.jp [61.114.244.165])
	by alpsgiken.alpsgiken.gr.jp (8.9.1a/3.7W) with ESMTP id LAA24495;
	Mon, 23 Jun 2003 11:29:42 +0900
Date: Mon, 23 Jun 2003 11:32:16 +0900
From: Joel Rees <joel@alpsgiken.gr.jp>
To: Konrad Scorciapino <fallenbr@uol.com.br>,
	freebsd-questions@freebsd.org
In-Reply-To: <20030622194538.141630d0.fallenbr@uol.com.br>
References: <20030622194538.141630d0.fallenbr@uol.com.br>
Message-Id: <20030623112512.2435.JOEL@alpsgiken.gr.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Becky! ver. 2.00.11
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:29:51 -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.

Connect as the (MySQL) root user and take a look at the "mysql" database.
Note that passwords are assigned, not to just a user name, but to the
combination of user and host.

MySQL has their own mailing lists, with archives available at marc and
other places, BTW.

-- 
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp