I did the following and mysql started but then I stopped the server and pid file gone and then mysql couldn't create it again:
bash-3.2# mkfile -nv 0b panosru-mac.local.pid
panosru-mac.local.pid 0 bytes
bash-3.2# chown zend:wheel panosru-mac.local.pid
bash-3.2# chmod -rw-rw---- panosru-mac.local.pid
EDIT2:bash-3.2# ./zendctl.sh start
Starting ZendServer 4.0.5 ..
/usr/local/zend/bin/apachectl start [OK]
spawn-fcgi: child spawned successfully: PID: 45486
Starting ZendServer GUI [Lighttpd] [OK]
[ 16.09.2009 15:19:12 SYSTEM] watchdog for lighttpd is running.
[ 16.09.2009 15:19:12 SYSTEM] lighttpd is running.
Starting Java bridge [OK]
[ 16.09.2009 15:19:12 SYSTEM] watchdog for java_daemon is running.
[ 16.09.2009 15:19:12 SYSTEM] java_daemon is running.
Ok I fixed everything by re-installing zend server and chown zend:wheel the backed up tables of mysql.
How can I set a password for my mysql? I tried change password from phpmyadmin but then I could never login again and I re-installed the server again
Ok I edited my.cnf and now everything works like before! :)