From owner-freebsd-questions@FreeBSD.ORG  Sun Nov 30 13:57:58 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 6950616A4CE
	for <questions@FreeBSD.ORG>; Sun, 30 Nov 2003 13:57:58 -0800 (PST)
Received: from fielden.com.au (www.fielden.com.au [203.34.58.131])
	by mx1.FreeBSD.org (Postfix) with SMTP id 989FE43FB1
	for <questions@FreeBSD.ORG>; Sun, 30 Nov 2003 13:57:45 -0800 (PST)
	(envelope-from david@fielden.com.au)
Received: (qmail 6107 invoked from network); 30 Nov 2003 21:57:31 -0000
Received: from unknown (HELO F84) (192.168.1.84)
  by persephone.fielden.com.au with SMTP; 30 Nov 2003 21:57:31 -0000
From: "DG" <david@fielden.com.au>
To: "'FreeBSD-questions'" <questions@FreeBSD.ORG>
Date: Mon, 1 Dec 2003 08:57:29 +1100
Message-ID: <002b01c3b78c$f37a2a40$5401a8c0@borg.fielden.com.au>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
In-Reply-To: <200311301754.09828.freebsd-questions@webteckies.org>
Subject: RE: MySQL question...
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, 30 Nov 2003 21:57:58 -0000

> -----Original Message-----
> From: owner-freebsd-questions@freebsd.org
> [mailto:owner-freebsd-questions@freebsd.org]On Behalf Of
> Melvyn Sopacua
> Sent: Monday, 1 December 2003 3:54 AM
> To: FreeBSD-questions
> Cc: Xpression
> Subject: Re: MySQL question...
>
<snip>
>
> All databases will go under /var/db/mysql and the quick and
> dirty answer is:
> mysql -e "GRANT ALL ON $dbname.* TO '$dbuser'@'localhost'
> IDENTIFIED BY
> '$userpasswd'"
>
> --
> Melvyn

Something I've wondered is why the default location for the MySQL databasi
is /var/db/mysql?  Yes /var/db seems to make sense, but most /var
filesystems would be fairly small.

Is it generally common practice to create a symbolic link to somewhere on,
say, /usr to store the databasi?

Dave