From owner-freebsd-questions@FreeBSD.ORG  Mon Jun 11 22:11:56 2012
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 7631410656F1
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 22:11:56 +0000 (UTC)
	(envelope-from freebsd@dreamchaser.org)
Received: from nightmare.dreamchaser.org (nightmare.dreamchaser.org
	[12.32.44.142]) by mx1.freebsd.org (Postfix) with ESMTP id 3F57F8FC1D
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 22:11:56 +0000 (UTC)
Received: from breakaway.dreamchaser.org (breakaway.dreamchaser.org.
	[12.32.36.73])
	by nightmare.dreamchaser.org (8.13.6/8.13.6) with ESMTP id
	q5BMBsjx031530; Mon, 11 Jun 2012 16:11:54 -0600 (MDT)
	(envelope-from freebsd@dreamchaser.org)
Message-ID: <4FD66D2A.6070001@dreamchaser.org>
Date: Mon, 11 Jun 2012 16:11:54 -0600
From: Gary Aitken <freebsd@dreamchaser.org>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:13.0) Gecko/20120609 Thunderbird/13.0
MIME-Version: 1.0
To: Robert Bonomi <bonomi@mail.r-bonomi.com>
References: <201206111948.q5BJmYoK019188@mail.r-bonomi.com>
In-Reply-To: <201206111948.q5BJmYoK019188@mail.r-bonomi.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2
	(nightmare.dreamchaser.org [12.32.36.65]);
	Mon, 11 Jun 2012 16:11:54 -0600 (MDT)
Cc: freebsd-questions@freebsd.org
Subject: Re: mysqld startup issue
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: freebsd@dreamchaser.org
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 22:11:56 -0000

On 06/11/12 13:48, Robert Bonomi wrote:

>> 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.

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

nope, and yup
nope, because the docs clearly state that the server needs to be running.
yup, because I did it anyway just to see what it would do

> If so, what happened?

Unsurprisingly, it craps out saying it cannot connect to the server.

problem was missing --datadir option when starting server