From owner-freebsd-questions@FreeBSD.ORG Sun Jan 10 19:08:42 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1DAFA106566B for ; Sun, 10 Jan 2010 19:08:42 +0000 (UTC) (envelope-from wblock@wonkity.com) Received: from wonkity.com (wonkity.com [67.158.26.137]) by mx1.freebsd.org (Postfix) with ESMTP id CE0158FC16 for ; Sun, 10 Jan 2010 19:08:41 +0000 (UTC) Received: from wonkity.com (localhost [127.0.0.1]) by wonkity.com (8.14.3/8.14.3) with ESMTP id o0AJ8eCQ078154; Sun, 10 Jan 2010 12:08:40 -0700 (MST) (envelope-from wblock@wonkity.com) Received: from localhost (wblock@localhost) by wonkity.com (8.14.3/8.14.3/Submit) with ESMTP id o0AJ8e4H078151; Sun, 10 Jan 2010 12:08:40 -0700 (MST) (envelope-from wblock@wonkity.com) Date: Sun, 10 Jan 2010 12:08:40 -0700 (MST) From: Warren Block To: jaymax In-Reply-To: <27100257.post@talk.nabble.com> Message-ID: References: <27100257.post@talk.nabble.com> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.2.3 (wonkity.com [127.0.0.1]); Sun, 10 Jan 2010 12:08:40 -0700 (MST) Cc: freebsd-questions@freebsd.org Subject: Re: Catastrophic Installation Failure now! X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 10 Jan 2010 19:08:42 -0000 On Sun, 10 Jan 2010, jaymax wrote: > > MAJOR SCREWUP > > I was frustrated by a failure to create a ROOT password and decided to do a > clean reinstall > Did a "make deinstall" from the following ports > > [i] /usr/ports/databases/mysql54-server > [ii] /usr/ports/databases/mysql54-client > [iii] /usr/ports/databases/mysql54-scripts > > Did a rm of the /etc/my.cnf file (There were no others in related or > relevant areas) FreeBSD standard should be in /usr/local/etc. I don't know mysql, though. > Reinstallation proceeded as follows: > in /usr/ports/databases/mysql54-server ==> > make 'pager=more' 'prompt=mysql54' 'socket=/usr/tmp/mysql.sock' > 'localstatedir=/disk02/db/mysql/DATA' 'with_linuxthreads=yes' 'with_ssl=yes' > install clean & > > in /usr/ports/databases/mysql54-scripts ==> > make install clean > > mysql client apparently installed as a dependency by the server Those are outdated ports, or at least the only thing close in my ports tree is mysql55. > Did the following: > [i] /usr/local/bin/mysql_install_db then > [ii] /usr/local/bin/mysqld_safe & first startup > > Stdout ==> > [1] 37786 > ax# 100110 07:05:36 mysqld_safe Logging to > '/disk02/db/mysql/DATA/ax.lall.com.err'. ... > 100110 7:05:38 [ERROR] Fatal error: Can't open and lock privilege tables: > Can't find file: './mysql/host.frm' (errno: 13) According to some web searching, host.frm is supposed to be created by mysql_install_db. Looking at the log file it created may help; suspect directory ownership or permissions, or maybe it is working in the wrong directory entirely. -Warren Block * Rapid City, South Dakota USA