Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 01 Feb 2007 10:58:05 -0600
From:      Martin McCormick <martin@dc.cis.okstate.edu>
To:        freebsd-questions@freebsd.org
Subject:   mysql5.1-server Refuses to Start.
Message-ID:  <200702011658.l11Gw5xV029725@dc.cis.okstate.edu>

Next in thread | Raw E-Mail | Index | Archive | Help
	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



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?200702011658.l11Gw5xV029725>