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 > _______________________________________________ > email@example.com mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > _______________________________________________ firstname.lastname@example.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"