Women in Technology

Hear us Roar

  Apache Web-Serving With Mac OS X, Part 5
Subject:   mysqld ended...waaahhh
Date:   2003-06-13 12:57:35
From:   anonymous2
Response to: mysqld ended...waaahhh

This is probably it:

The databases installed in the mysql data directory, /var/lib/mysql are not owned by the
mysql user, but by the user who ran
mysql_install_db. chown them to mysql and chgrp
them to the appropriate group e.g.

chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql

Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • mysqld ended...waaahhh
    2008-02-09 14:56:25  sriv1211 [View]

    to that anonymous2 guy:
    thanks so much for that comment - i've been trying for days literally to find out the reason. i know that u posted the comment in 2003, and its now 2008, u may never read this post again, but thanks so much for that simple sollution!!!!!
  • mysqld ended...waaahhh
    2004-02-05 14:21:10  manshreck [View]

    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
    • 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!