From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 28 23:52:57 2003
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 BA81016A4BF
	for <freebsd-questions@FreeBSD.ORG>;
	Thu, 28 Aug 2003 23:52:57 -0700 (PDT)
Received: from hotmail.com (law11-f32.law11.hotmail.com [64.4.17.32])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 297B743FE5
	for <freebsd-questions@FreeBSD.ORG>;
	Thu, 28 Aug 2003 23:52:57 -0700 (PDT)
	(envelope-from nuckingfutsto@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Thu, 28 Aug 2003 23:52:57 -0700
Received: from 24.195.167.45 by lw11fd.law11.hotmail.msn.com with HTTP;
	Fri, 29 Aug 2003 06:52:56 GMT
X-Originating-IP: [24.195.167.45]
X-Originating-Email: [nuckingfutsto@hotmail.com]
From: "Ben Dover" <nuckingfutsto@hotmail.com>
To: freebsd-questions@FreeBSD.ORG
Date: Fri, 29 Aug 2003 02:52:56 -0400
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <Law11-F32QZaWcOrlVa0000c96b@hotmail.com>
X-OriginalArrivalTime: 29 Aug 2003 06:52:57.0043 (UTC)
	FILETIME=[2D93FA30:01C36DFA]
Subject: MYSQL Fresh Reinstall, How?
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: Fri, 29 Aug 2003 06:52:57 -0000

   I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it 
straightened out.  I think the best way to resolve this would be to do a 
fresh install of MYSQL server.  I did a pkg_delete of MYSQL-server and 
client and installed again from ports but I'm getting the same error 
messages.  Is there a way to just start out fresh like I never had MYSQL 
installed in the first place? The error I'm getting is:
030829  2:36:36  Fatal error: Can't open privilege tables: Can't find file: 
'./mysql/host.frm' (errno: 13)
030829 02:36:36  mysqld ended

This started out from something I did while trying to get Plesk6 to work on 
5.1 (which I did) but without MYSQL working I uninstalled Plesk6. I think 
what I did was delete the database mysql and I guess it is essential.  Any 
assistance would be appreciated but I'm leaning toward a fresh install if 
possible.

_________________________________________________________________
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup