As the MySQL extensions with Zend Server are out of date, I decided to update them as it’s pretty simple to do.
Install the source package:
sudo apt-get install php-5.2-source-zend-server
sudo apt-get install php-5.3-source-zend-server
Install the MySQL client dev package:
sudo apt-get install libmysqlclient16-dev
sudo apt-get install autoconf
From this point onwards I ran as root as saves time having to sudo everything, I have also created symlinks for the binaries in /usr/local/zend/bin to /usr/local (php, phpize, php-config, pear, pecl etc)
Change to the extensions directory of the source you just installed:
There are 3 extensions that need to be recompiled mysql, mysqli and pdo_mysql, the following procedure is the same for all 3:
cp modules/mysql.so /usr/local/zend/lib/php_extensions/
Finally restart Zend Server and all the MySQL extensions will be using the latest libraries.