From owner-freebsd-questions@FreeBSD.ORG Fri Aug 29 01:22:10 2003 Return-Path: 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 D731E16A4BF for ; Fri, 29 Aug 2003 01:22:10 -0700 (PDT) Received: from mail.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by mx1.FreeBSD.org (Postfix) with ESMTP id BAAB243FE3 for ; Fri, 29 Aug 2003 01:22:09 -0700 (PDT) (envelope-from freebsd@soith.com) Received: from www.fastmail.fm (localhost [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id CCA4614E2A7; Fri, 29 Aug 2003 04:22:08 -0400 (EDT) Received: from 10.202.2.132 ([10.202.2.132] helo=www.fastmail.fm) by messagingengine.com with SMTP; Fri, 29 Aug 2003 04:22:08 -0400 Received: by www.fastmail.fm (Postfix, from userid 99) id 90CD23A291; Fri, 29 Aug 2003 04:22:08 -0400 (EDT) Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MIME::Lite 1.2 (F2.71; T1.001; A1.51; B2.12; Q2.03) From: "Aaron Wohl" To: "Ben Dover" , freebsd-questions@FreeBSD.ORG Date: Fri, 29 Aug 2003 02:22:08 -0600 X-Epoch: 1062145328 X-Sasl-enc: rYpfAzrbXzToCQljIczfjw References: In-Reply-To: Message-Id: <20030829082208.90CD23A291@www.fastmail.fm> Subject: Re: MYSQL Fresh Reinstall, How? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 29 Aug 2003 08:22:11 -0000 Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave you with a working mysql database lately. What did to fix it was mysqld -u mysql --skip-grant & (Im assuming you have your mysql firewalled off, if not do that first ;) At that point mysql is up enough to restore the mysql database. I ran msyql mysql < mysql.sql where mysql.sql was made from mysqldump of a working mysql. Then mysqladmin shutdown. Then your fine after that for normal operations. I am using innodb as the default table type. I dont know if you are or if that matters. On Fri, 29 Aug 2003 02:52:56 -0400, "Ben Dover" said: > 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 > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org"