From owner-freebsd-questions@FreeBSD.ORG Thu Feb 1 16:58:06 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 504AC16A401 for ; Thu, 1 Feb 2007 16:58:06 +0000 (UTC) (envelope-from martin@dc.cis.okstate.edu) Received: from dc.cis.okstate.edu (dc.cis.okstate.edu [139.78.100.219]) by mx1.freebsd.org (Postfix) with ESMTP id 2D84713C494 for ; Thu, 1 Feb 2007 16:58:05 +0000 (UTC) (envelope-from martin@dc.cis.okstate.edu) Received: from dc.cis.okstate.edu (localhost.okstate.edu [127.0.0.1]) by dc.cis.okstate.edu (8.13.3/8.13.3) with ESMTP id l11Gw5xV029725 for ; Thu, 1 Feb 2007 10:58:05 -0600 (CST) (envelope-from martin@dc.cis.okstate.edu) Message-Id: <200702011658.l11Gw5xV029725@dc.cis.okstate.edu> To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <29723.1170349085.1@dc.cis.okstate.edu> Date: Thu, 01 Feb 2007 10:58:05 -0600 From: Martin McCormick Subject: 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 16:58:06 -0000 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