From owner-freebsd-questions@FreeBSD.ORG  Tue Jul 28 02:30:05 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 6C0FB1065670
	for <freebsd-questions@freebsd.org>;
	Tue, 28 Jul 2009 02:30:05 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net)
Received: from mailhub.rachie.is-a-geek.net (rachie.is-a-geek.net
	[66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id 3A4FC8FC19
	for <freebsd-questions@freebsd.org>;
	Tue, 28 Jul 2009 02:30:04 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net)
Received: from smoochies.rachie.is-a-geek.net
	(mailhub.lan.rachie.is-a-geek.net [192.168.2.11])
	by mailhub.rachie.is-a-geek.net (Postfix) with ESMTP id 3A8C97E818;
	Mon, 27 Jul 2009 18:30:04 -0800 (AKDT)
From: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net>
To: freebsd-questions@freebsd.org
Date: Mon, 27 Jul 2009 18:30:02 -0800
User-Agent: KMail/1.11.4 (FreeBSD/8.0-BETA2; KDE/4.2.4; i386; ; )
References: <5a1fc34c0907271836l5a38700cg252f8ea10a253938@mail.gmail.com>
	<ade45ae90907271921w7cc2e874t718490834d33257f@mail.gmail.com>
In-Reply-To: <ade45ae90907271921w7cc2e874t718490834d33257f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200907271830.03006.mel.flynn+fbsd.questions@mailing.thruhere.net>
Cc: Tim Judd <tajudd@gmail.com>, Stew Houston <stewhouston@gmail.com>
Subject: Re: mysql50-server root login
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
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: Tue, 28 Jul 2009 02:30:05 -0000

On Monday 27 July 2009 18:21:04 Tim Judd wrote:
> After running mysql_install_db, the mysql files are owned by
> root:wheel instead of mysql:mysql
>
> I've noticed that is a missing step in the docs.
> # mysql_install_db
> # chown -R mysql:mysql /var/db/mysql

Or...you can just not do this at all.

> # /usr/local/etc/rc.d/mysql start

Will create the auth tables, if they don't exist, with the correct ownerships:

mysql_prestart()
{
        if [ ! -d "${mysql_dbdir}/mysql/." ]; then
                mysql_create_auth_tables || return 1
        fi

-- 
Mel