mac osx server and mysql

[Ryan Schmidt]

On Mar 30, 2007, at 12:37, grimmwerks wrote:

> I've actually installed everything fine; the problem is it's on  
> macosx server, and it's more stringent with it's permissions. It  
> seems that I can't create the database file or write to it as user  
> mysql (which is what mysql would be saving as, correct?)

In which way is Mac OS X Server more stringent with its permissions?  
I have not used Mac OS X Server in the past several years, so maybe  
something has changed that I don't know about, but Mac OS X Server  
certainly used to be exactly the same as Mac OS X client, just with a  
few more apps and services installed.

> I thought I could find the directory and chmod 777 it?

Wouldn't it be much better just to assign the ownership to the mysql  
user?

sudo chown mysql:mysql /opt/local/var/db/mysql5

In fact I was under the impression that this was done automatically  
for you when you initially create the database using the command  
printed at the end of the mysql5 port installation. Did this not  
happen for you?

Are you seeing error messages? If so, what are they?