Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 01 Feb 2007 14:17:17 -0500
From:      Dan Casey <dcasey@debtresolve.com>
To:        Martin McCormick <martin@dc.cis.okstate.edu>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql5.1-server Refuses to Start.
Message-ID:  <45C23CBD.6070405@debtresolve.com>
In-Reply-To: <200702011658.l11Gw5xV029725@dc.cis.okstate.edu>
References:  <200702011658.l11Gw5xV029725@dc.cis.okstate.edu>

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 '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"
>   



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?45C23CBD.6070405>