Obviously I understand the need to ensure that different software versions are compatible, which is why it is frustrating to have spent the last three days finding out about incompatibilities with MySQL 6.0 Community Version. That is 3 days overall, having also eaten, drank, gone to work and watched Doctor Who in between you understand, not 72 hours of solid annoyance time. Still...
Having installed MySQL6.0 on localhost and installed WordPress2.5 to work with it, I noticed that some of the WordPress features weren't working as they should: you couldn't display draft posts for example. I put this down to possible WordPress issues and moved on to getting WordPress to work with the Simple Machines Forum (SMF) 1.1.4 forum using the same database (to mirror the operation of our server). It was here that I discovered that I simply couldn't get the forum to work with any MySQL database, which was odd, as I had managed to install it a while ago on my laptop. So I started to debug the PHP, and it was then that it clicked: it all worked with MySQL 5.0, but not with MySQL 6.0. Couldn't find anything on the Internet to confirm this, but a quick uninstall of 6.0 and install of 5.0 and it all works swimmingly. And both WordPress and SMF use the same database. Brilliant!! But so much hassle ...
On a related note, to install MySQL 5.0, it is necessary to install it at C:\MySQL\ rather than the path the installer suggests. Otherwise there is a whole load of pain to go through to configure it. Instead, go to C:\MySQL\bin and type 'mysqld-nt.exe --install', then 'net start mysql' and it is all up and running. That simple... And only three days work (obvious caveats apply) to get it working....!
