mysql5: is it running and how can I tell?

[markd at macports.org]

"paul beard" <paulbeard at gmail.com> on Monday, July 9, 2007 at 11:03 PM
-0800 wrote:
>My guess is that it isn't. And I don't know why. Using ps gives me this. 
>
>root        47   0.0  0.1    27884    816  ??  Ss   10:46PM   0:00.04
>/opt/local/bin/daemondo --label=mysql5 --start-cmd
>/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ;
>--stop-cmd
>/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ;
>--restart-cmd
>/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ;
>--pid=/opt/local/var/mysql.pid 
>
>
>running the script by hand gives me this. 
>
>
>/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start 
>Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 159: kill:
>(580) - No such process
>
>
>the offending line 159? 
>
>
>    152 wait_for_pid () {
>    153   i=0
>    154   while test $i -ne $service_startup_timeout ; do
>    155     sleep 1
>    156     case "$1" in
>    157       'created') 
>    158         test -s $pid_file && i='' && break
>    159         kill -0 $2 || break # if the program goes away, stop
>waiting
>    160         ;;
>    161       'removed') 
>
>
>and I get these messages now: 
>Workaround Bonjour: Unknown error: 0
>
>
>I don't think they are anything to do with mysql, perhaps apache2 since
>it doesn't do zeroconf stuff like the vendor-supplied httpd.  

Yeah, doesn't look like it is running because I don't see mysqld running
in the ps output.  The Bonjour message is unrelated, though I'm not sure
why they occur.  Is it a new install, and if so have you run
mysql_install_db5?  Here is how I setup mysql5.

http://homepage.mac.com/duling/halfdozen/NeDi-Howto.html#d0e94

Mark