mysql5.1-server Refuses to Start.
martin at dc.cis.okstate.edu
Thu Feb 1 16:58:06 UTC 2007
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
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.
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
OSU Information Technology Department Network Operations Group
More information about the freebsd-questions