WordPress won’t connect to mysql

Hi,

I just installed MySQL for wordpress on a new box of mine and everything went smoothly and I can connect through the MySQL Administrator just fine, but when I try to connect with wordpress it tells me it can’t connect to the database.

I had this same problem on a machine I configured just last week and I fixed it by enabling named pipes. The only difference between that machine and this one is that one was running Windows Server 2003 (32-bit) and this one is running Windows Server 2008 (64-bit). The other difference is that this machine has multiple IP addresses associated with it. The other one just has one (I feel like the problem is in here somewhere, but I don’t really know).

I had a similar problem several years ago with a MySQL/wordpress setup where I ended up enabling something that allowed me to just put a “.” instead of localhost and that allowed it to connect (same thing on that machine with multiple IPs).

Any ideas what I’m doing wrong here? I have quadruply checked the info in my wp-config file is correct and should be able to connect to the database. I also use the exact same login info to access the database through MySQL Admin, so I know that part is correct.

My system is using Windows Server 2008. MySQL 5.1.48

My config has set named pipes and TCP/IP on port 3306 and is configured to allow TCP/IP connections.

I’ve tried setting the wordpress host connection to localhost, localhost:3306, just dot (.), 127.0.0.1, 127.0.0.1:3306, etc. Nothing works. However, when I do localhost or 127.0.0.1, it thinks about it for a long time before erroring out. With other things it tells me right away it is no good.

Along the multiple IP theme, could I need to enable remote connections somewhere or something like that?

Any help would be much appreciated.