Date: 18-02-13 19:54
Recently installed FreeBSD 9.1 to rebuild a webserver and attempted a mysql 5.5 install. Everything seemed to go fine until I attempted to start the SQL server up. I can't seem to move passed this error:
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
I've tweaked the my.cnf file to point the data dir to /var/db/mysql (which has a ton of files, but no actual directory called 'data'. Does this matter?). I've also executed the mysql_install_db with --user=mysql and --ldata=/var/db/mysql flags. It dumped a bunch of files in there, but I'm still having start up errors. Google has failed me (most of the answers are for linux) and I'm about ready to drop kick this sucker out the window.
Surely someone else has come across this issue in FreeBSD and has figured it out by now? Any help is greatly appreciated!