From owner-freebsd-questions@FreeBSD.ORG  Wed Apr 20 11:49:38 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 EC68316A4D5
	for <freebsd-questions@freebsd.org>;
	Wed, 20 Apr 2005 11:49:38 +0000 (GMT)
Received: from lakermmtao03.cox.net (lakermmtao03.cox.net [68.230.240.36])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5D90C43D39
	for <freebsd-questions@freebsd.org>;
	Wed, 20 Apr 2005 11:49:38 +0000 (GMT)	(envelope-from rjhjr@cox.net)
Received: from localhost ([68.230.186.138]) by lakermmtao03.cox.net
          (InterMail vM.6.01.04.00 201-2131-118-20041027) with ESMTP
          id <20050420114937.RLXU2673.lakermmtao03.cox.net@localhost>
          for <freebsd-questions@freebsd.org>;
          Wed, 20 Apr 2005 07:49:37 -0400
Date: Wed, 20 Apr 2005 07:49:37 -0400
From: Bob Hall <rjhjr@cox.net>
To: freebsd-questions@freebsd.org
Message-ID: <20050420114936.GA94042@kongemord.krig.net>
Mail-Followup-To: Bob Hall <rjhjr@cox.net>,
	freebsd-questions@freebsd.org
References: <20050420032237.3CA7616A4EE@hub.freebsd.org>
	<4266398B.9000803@uk2.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4266398B.9000803@uk2.net>
User-Agent: Mutt/1.4.2.1i
Subject: Re: 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:49:39 -0000

On Wed, Apr 20, 2005 at 12:14:19PM +0100, Graham Bentley wrote:
> 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.

This is a very MySQL specific question. You should post it to the MySQL
mailing list. 

It's been a while since I used MySQL. The host table is in the MySQL
database. There should be a directory called data, or something similar,
and inside that there is a directory called mysql, and inside that there
is a file called host, which contains the host table. Or at least,
that's what I remember. Either that file is missing, or the system
permissions on it have changed, or MySQL has changed access privileges
on it. Or something. Check to make sure that it is there, and has the
correct system permissions (ls -l). If it's not there, you may have to
back up all your tables and reinstall. Or you may be able to reinstall
just the host table. Further questions should go to a MySQL mailing
list.

Bob Hall