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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200702011658.l11Gw5xV029725>