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