From owner-freebsd-questions@FreeBSD.ORG  Wed Apr 20 11:10:54 2005
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 E817E16A4CE
	for <freebsd-questions@freebsd.org>;
	Wed, 20 Apr 2005 11:10:54 +0000 (GMT)
Received: from ptb-relay03.plus.net (ptb-relay03.plus.net [212.159.14.214])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A7F6943D41
	for <freebsd-questions@freebsd.org>;
	Wed, 20 Apr 2005 11:10:54 +0000 (GMT)
	(envelope-from gbentley@uk2.net)
Received: from [81.174.174.115] (helo=[192.168.7.20])
	 by ptb-relay03.plus.net with esmtp (Exim) id 1DOD6b-000JW6-8G
	for freebsd-questions@freebsd.org; Wed, 20 Apr 2005 11:10:53 +0000
Message-ID: <4266398B.9000803@uk2.net>
Date: Wed, 20 Apr 2005 12:14:19 +0100
From: Graham Bentley <gbentley@uk2.net>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
References: <20050420032237.3CA7616A4EE@hub.freebsd.org>
In-Reply-To: <20050420032237.3CA7616A4EE@hub.freebsd.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: MySQL Server died yesterday !
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: Wed, 20 Apr 2005 11:10:55 -0000

Hello All !

I made quite a few changes to my system recently
but havent touched any MySQL specific stuff.

When I came to check my forum it was dead
with an unable to connect error :(

This is in the logs and is recorded every
time I reboot or start manaully with

/usr/local/etc/rc.d/mysql-server.sh start

12:05:43  mysqld started
12:05:44  InnoDB: Started
12:05:44  Fatal error: Can't open privilege tables: Table 'mysql.host' 
doesn't exist
12:05:44  Aborting
12:05:44  InnoDB: Starting shutdown...
12:05:46  InnoDB: Shutdown completed
12:05:46  /usr/local/libexec/mysqld: Shutdown Complete

I have googled on this and read various sections of
the MySQl manual but cant seem to nail it - nothing seem specific
to my issue.

Some links suggested reinitialising my DB but
am not sure how to go about that.

Any help appreciated !

Graham