Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 01 Feb 2007 14:17:17 -0500
From:      Dan Casey <>
To:        Martin McCormick <>
Subject:   Re: mysql5.1-server Refuses to Start.
Message-ID:  <>
In-Reply-To: <>
References:  <>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
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 '' 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
> _______________________________________________
> mailing list
> To unsubscribe, send any mail to ""

Want to link to this message? Use this URL: <>