Spent all day trouble shooting my new installation of wordpress on my Windows Server 2003 and can not get WordPress to connect to MySQL.
I am running MySQL 5.5.16 and it seems to be working. The connection and server instance are set up and the test function says the setup parameters are correct. The only thing that looks odd is that in the Admin area of workbench it says"Host: Not Set" but it shows all the activity graphs etc.
Windwos is running MySql as a service
PHP knows where MySQL is and that it is running
Nslookup 127.0.0.1 resolves to localhost
telenet to localhost 3306 creates a connection
and I can run MySql commands from the command line.
But everytime it run wp-admin/install.php I get an error. I have tried all kinds of settings and nothing works.
Anyone know how to fix this? After eight hours of fighting this I am tapped out of ideas.