(this was also posted on macosxhints.com)
I recently upgraded MySQL to 4.1.21, and it seemed to go off successfully. Terminal shows my version is 4.1.21, as does the fresh install of phpMyAdmin I installed. Everything I was doing before is still working great.
However, I can't get subqueries to work, and phpinfo is showing mysql's "client API version" as 3.23.49. So it looks like something didn't "take", or maybe PHP isn't recognizing the new version??
I ran the official mysql fix permissions script after upgrading, and basically did everything Marc Liyanage's site told me to (http://www.entropy.ch/software/MacOSx/mysql/).
I'm running PHP 4.3.11, OS X 10.4.7, Apache 1.3.33
I got a response that said I needed to upgrade PHP's mysql client, but I don't know how to do this and haven't found an answer via googling - do I just re-install PHP 4.3.11 (using Liyanage's binary)?
Thanks!
