Women in Technology

Hear us Roar

Subject:   mysqld ended...waaahhh
Date:   2004-02-05 14:21:10
From:   manshreck
Response to: mysqld ended...waaahhh

By the way, this worked, but in Mac OS X 10.2 you need to set permissions on the "data" and "bin" directories within the MySQL installation (assuming you have MySQL startup automatically as the mysql user). That is:

user% sudo chown -R mysql /usr/local/mysql/data
user% sudo chown -R mysql /usr/local/mysql/bin
user% sudo chgrp -R mysql /usr/local/mysql/data
user% sudo chgrp -R mysql /usr/local/mysql/bin

Note: I keep both user and group as mysql

Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • mysqld ended...waaahhh
    2009-09-19 21:27:15  atrerus [View]

    I had the same issue on OSX 10.5. The problem seems to be that OSX puts underscores before all non "User" accounts, so the MySQL user is '_mysql'. When you attempt to start the service it blows up because it's expecting the directories to be owned by the user 'mysql' but they are actually owned by '_mysql'.

    That's speculation on my part, but I do know that by chowning the database directory to 'mysql' I was able to get things to work. Thanks for the tip!