View Single Post
  #9   (View Single Post)  
Old 3rd November 2009
Carpetsmoker's Avatar
Carpetsmoker Carpetsmoker is offline
Real Name: Martin
Tcpdump Spy
 
Join Date: Apr 2008
Location: Netherlands
Posts: 2,243
Default

Quote:
Originally Posted by phoenix View Post
If this is a fresh install, you may also have to initialise the internal database and tables. The rc.d script is supposed to do this automatically, but sometimes it doesn't. Try running the following:
# /usr/local/bin/mysql_install_db
And then running the rc.d script.

If that doesn't work, check /var/log/messages and the mysql logs in /var/db/mysql.
You should run:
# mysql_install_db --user=mysql

Otherwise the ownership for the MySQL database are set to root:wheel, and since mysqld_safe is run as the mysql user ...

If you've already run mysql_install_db, then just remove the /var/db/mysql directory and re-run the command with the --user argument (Assuming, ofcourse, there is nothing of value in /var/db/mysql).
__________________
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things.
Reply With Quote