Skip to content


Zend Server CE – MySQL Issues Snow Leopard OS X 10.6

Having recently made the transition to Snow Leopard and a new Mac Book Pro I decided to go with Zend Server CE as my LAMP stack.

I have noticed that I occasionally have isues relating to MySQL.

If you notice that mysql stops working properly and/or you receive the following error while trying to restart zend server:

ERROR! MySQL manager or server PID file could not be found!

You can run the following commands to get running again without having to reboot your machine.

First: Stop MySQL

sudo zendctl.sh stop-mysql

Second: Kill MySQL Processes.

ps aux | grep "mysql"

This should return something that looks like this..

zend      2520   0.0  0.3   640396  14616 s000  S     4:27PM   0:00.37 /usr/local/zend/mysql/bin/mysqld --defaults-extra-file=/usr/local/zend/mysql/data/my.cnf --basedir=/usr/local/zend/mysql --datadir=/usr/local/zend/mysql/data --user=zend --log-error=/usr/local/zend/mysql/data/xxx.err --pid-file=/usr/local/zend/mysql/data/xxx.pid --socket=/usr/local/zend/mysql/tmp/mysql.sock --port=3306
root      2388   0.0  0.0  2435464    864 s000  S     4:27PM   0:00.03 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/zend/mysql/data --pid-file=/usr/local/zend/mysql/data/xxx.pid

Now, the PID number you are looking for is the first set of numbers after the username. Repeat the kill command until all your MySQL processes are dead.
Example:

sudo kill -9 2520
sudo kill -9 2388

Now we want to restart MySQL

sudo zendctl.sh start-mysql

This will temporarily get you back on track. I am working on a permanent solution to this problem, will keep you posted.

Happy Coding!

Posted in MySQL, Snow Leopard, Zend Server.

One Response

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Thanks Man!

Some HTML is OK

(required)

(required, but never shared)

or, reply to this post via trackback.