From owner-freebsd-questions@FreeBSD.ORG Thu Feb 1 19:17:28 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 9990116A400 for ; Thu, 1 Feb 2007 19:17:28 +0000 (UTC) (envelope-from dcasey@debtresolve.com) Received: from debtresolve.com (ip175-18.wp-ny-us.debtresolve.com [66.236.175.18]) by mx1.freebsd.org (Postfix) with ESMTP id 4B87213C4B4 for ; Thu, 1 Feb 2007 19:17:27 +0000 (UTC) (envelope-from dcasey@debtresolve.com) Received: from dummy.name; Thu, 01 Feb 2007 14:17:30 -0500 Message-ID: <45C23CBD.6070405@debtresolve.com> Date: Thu, 01 Feb 2007 14:17:17 -0500 From: Dan Casey User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Martin McCormick References: <200702011658.l11Gw5xV029725@dc.cis.okstate.edu> In-Reply-To: <200702011658.l11Gw5xV029725@dc.cis.okstate.edu> X-Enigmail-Version: 0.94.1.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: mysql5.1-server Refuses to Start. 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: Thu, 01 Feb 2007 19:17:28 -0000 Does the directory "/var/db/mysql/mysql" exist? If your missing that directory, then mysql cannot authenticate. I'm assuming this is a fresh install. Try backing up your files, then run mysql_install_db. This will create the mysql database for you. Martin McCormick wrote: > If one does a Google search on the following error > message from the mysql server, there is a long and painful > discussion ona mysql mailing list in which lots of people have > had the same exact problem. The solutions, however, were for Sun > Work Stations and a similar solution I tried here, had no effect > at all. > > I am trying to start mysqld in safe mode on a FreeBSD5.4 > system in such a way that only local users can access it. The > suggested command for this is > > /usr/local/bin/mysqld_safe --skip-networking --user=mysql > > The mysql server is defaulted to use /var/db/mysql and > that is where it appears to initially be happy. The mysql > directory is chowned to be owned by the user mysql and it does > start creating new table files: > > 070201 10:30:55 mysqld started > /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 070201 10:30:55 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > > mysql creates a couple more files and then disaster strikes! > > 070201 10:30:59 [ERROR] Fatal error: Can't open and lock privilege > tables: Table 'mysql.host' doesn't exist > 070201 10:30:59 mysqld ended > > I do have a my.cnf file in /usr/local but it only > contains one line which doesn't change anything. > > basedir=/var/db/mysql > > It seemed to already default to this directory. The datadir > variable which some of the posters mentioned is no longer needed. > > Has anybody gotten sqld_safe to work in FreeBSD? > > Martin McCormick WB5AGZ Stillwater, OK > Systems Engineer > OSU Information Technology Department Network Operations Group > _______________________________________________ > 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" >