Women in Technology

Article:		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

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!