From: Steffan A. Cline
Date: November 17 2007 7:05pm
Subject: Re: MySQL on Leopard
List-Archive: http://lists.mysql.com/mysql/210100
Message-Id: <C3648995.8C5C3%steffan@hldns.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

on 11/17/07 8:20 AM, William Allaire at maillist2@stripped wrote:

> 
> On Nov 17, 2007, at 4:06 AM, Steffan A. Cline wrote:
> 
>> Documentation for dscl is somewhat cryptic. When I was finally able
>> to list
>> the users I see that the usual uid and gid of 74 belongs to _mysql.
>> What is
>> the work around for this to change it to plain ole mysql so I can
>> get this
>> puppy working correctly again?
> 
> Steffan,
> Why not just use _mysql where you normally use mysql as the uid/gid?
> It would probably be easier than changing plist files from _mysql back
> to mysql.

Well, I figured it would be prudent to make it mimic the previous method to
make it all work correctly as it did before. Well, now I have run into a few
strange things.

Mimicking the _mysql user works:

Phat-G5:~ steffan$ sudo su -m _mysql
sh-3.2$ /usr/local/mysql/bin/mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/var


Using the tip for launchd does not seem to work.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN"
"http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>KeepAlive</key>
    <true/>
    <key>Label</key>
    <string>com.mysql.mysqld</string>
    <key>Program</key>
    <string>/usr/local/mysql/bin/mysqld_safe</string>
    <key>RunAtLoad</key>
    <true/>
    <key>UserName</key>
    <string>_mysql</string>
    <key>WorkingDirectory</key>
    <string>/usr/local/mysql</string>
</dict>
</plist>

I get no daemon running under ps -U _mysql when I use
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist
To launch it.

Anything I am missing here?



Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline 
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : steffan@stripped
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------