I have been running Moodle for a year on Server 2003 with IIS6, PHP 4.3.8,MySQL 4.0.20d and Moodle 1.3.4. During that time the server was taken offline and reformatted and Moodle was successfully reinstalled and configured.
I have recently talked management into purchasing a new whiz bang server to host all our web services (Intranet, Portal, Moodle). I thought it would be a good time to update the versions we were using so I downloaded PHP 4.3.10, MySQL 4.1.10 and Moodle 1.4.3. I followed my notes from previous installations and suddenly found myself getting 'cannot connect to database... etc' when I tried using the installation page (install.php). I have searched through these pages for guidance but none of the offered advice helped (I even formatted the server and started from scratch). In the end I removed MySQL 4.1.10 and installed MySQL 4.0.20d and tried again. Now when I use the installation page I can connect to the database and continue with the install (all the tables created successfully).
Obviously something significant changed from version 4.0 to 4.1 that affects the setup of Moodle. Two changes I noticed were a different installation path (c:\program files\...... instead of c:\mysql) and it wouldn't allow root to have a blank password (which is good) whereas the older version has a blank password by default.
Any ideas on what is wrong and how fix it?
PS. When in trouble try an older version!