RonChicago, the domain name solution was suggested above by Tower180 – I tried that. It didn’t work.
Shortly after I had this trouble with WP, I installed Drupal on one of my other sites, and had similar trouble with the databases, only to find that the problem stemmed from my server using an unusual port number for the MySQL5 database. Drupal made it easy to change the port number, but I haven’t figured out where that is set in the WP setup. I’m leaning toward trying MarcDelange’s syntax to see if that fixes the trouble.
I’ve found the same problem in my installation – if I use MySQL5, WP can’t find the database. If I use MySQL4, it works just fine, but when I tried to convert to MySQL5, once again, I had issues with WP trying to find the DB.
Is there an issue with the collation/encoding? My host defaults to latin1_general_ci for MySQL5 collation. MySQL4 is cp1252
Should I just get used to using MySQL4, since it works?
