From owner-freebsd-questions@FreeBSD.ORG  Mon Jun 11 19:48:08 2012
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 61DAD1065676
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 19:48:08 +0000 (UTC)
	(envelope-from bonomi@mail.r-bonomi.com)
Received: from mail.r-bonomi.com (mx-out.r-bonomi.com [204.87.227.120])
	by mx1.freebsd.org (Postfix) with ESMTP id C1B128FC0A
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 19:48:07 +0000 (UTC)
Received: (from bonomi@localhost)
	by mail.r-bonomi.com (8.14.4/rdb1) id q5BJmYoK019188;
	Mon, 11 Jun 2012 14:48:34 -0500 (CDT)
Date: Mon, 11 Jun 2012 14:48:34 -0500 (CDT)
From: Robert Bonomi <bonomi@mail.r-bonomi.com>
Message-Id: <201206111948.q5BJmYoK019188@mail.r-bonomi.com>
To: freebsd-questions@freebsd.org, freebsd@dreamchaser.org
In-Reply-To: <4FD62BA8.7030702@dreamchaser.org>
Cc: 
Subject: Re: mysqld startup issue
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: Mon, 11 Jun 2012 19:48:08 -0000


Gary Aitken wrote:
> To: FreeBSD Mailing List <freebsd-questions@freebsd.org>
> Subject: mysqld startup issue
>
> I've done the following after having a running system with a running mysql on it:
>
> moved user accounts, although no logical move:
>   /usr/home/foo was => /hd1/foo
> now
>   /usr/home => /hd1/home  and /hd1/foo is now /hd1/home/foo
> repartitioned the SSD and restored the system from a dump taken prior to repartitioning.
> removed all ports and reinstalled them
>
> Unfortunately, mysqld won't start:
>
[ sneck ]

> 120611 10:55:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

[ sneck ]
>
> This looks like some kind of access / setuid problem, but I'm not sure what.
> Suggestions?

Have you tried doing what the error message _tells_ you to do ?

If so, what happened?  

If not, why not?