mysql5.1-server Refuses to Start.

[Dan Casey]

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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>