The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]

FreeBSD Support
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 MySQL 5.5 Start Up Failure
Author: el_kab0ng 
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!

Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org