Forum Moderators: travelin cat
I've looked around for good instructions on how to upgrade the MySQL on OS X Server (Tiger) without success. Anyone seen one?
I turned off OS X Server's MySQL and installed MySQL 5 with the standard (64-bit) package on MySQL.com. At this point, I can't use the tools that came with OS X to manage MySQL.
(It'd be great if I could get those to recognize the new install, if there's a way to do that.)
Thus, in order for PHP and Postfix to use these, they'll also have to be re-installed. At present your PHP and Postfix installations are thus using the shared libraries from the stock Mac OS Server install of MySQL. This might lead to problems for you when using eg SquirrelMail.
Actually, if the compiling information at [dev.mysql.com...] is correct, you wont be able to link against this when re-compiling PHP and Postfix as the shared libraries aren't included in the binary distribution from MySQL.com.
If you just want to play around you can of course run both the 4.1 and 5.0 versions concurrently on different ports
Be aware that MySQL 5 comes with new shared libraries.
Little tidbit: My stock PHP seemed to be talking fine to fine to MySQL 5 on my laptop, but then I realized that's because I was allowing a connection (from localhost) without a password. (Yes, I know, not such a great idea.)
If you require a password, you get an error that it won't work unless you upgrade.
I took that as a cue to upgrade to PHP 5 (using Marc Liyanage's package) and this worked without a hitch on both OS X client and server.
Haven't played around with PostFix, though.
I'ld be interested in knowing what this search using Terminal gives as a result:
sudo find / -iname 'libmysqlclient*'
The new MySQL 5 dynamic libraries are version 15, the ones for MySQL 4.1 are version 12
sudo find / -iname 'libmysqlclient*'/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.la
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.la
/usr/local/mysql-standard-5.0.15-osx10.4-powerpc-64bit/lib/libmysqlclient.a
/usr/local/mysql-standard-5.0.15-osx10.4-powerpc-64bit/lib/libmysqlclient_r.a
