I have a large multisite installation hosted on XAMPP on an XP 2003 server and am trying to move it to a new Windows 2008 server with IIS7.
I can successfully get fresh installs of WP up and running and can get multisite working perfectly. But, when I import my old WPMS MySQL database and change the DB_NAME in my
wp-config.php file to have the old WPMS database instead of the new WPMS database, I'm hit with "Error establishing database connection"
Here are my wp-config.php settings:
// ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'migrated_WPMS_database'); /** MySQL database username */ define('DB_USER', 'wpms_user'); /** MySQL database password */ define('DB_PASSWORD', 'wpms_password'); /** MySQL hostname */ define('DB_HOST', 'localhost'); /** Database Charset to use in creating database tables. */ define('DB_CHARSET', 'utf8'); /** The Database Collate type. Don't change this if in doubt. */ define('DB_COLLATE', '');
I've double checked the username & password and even changed them several times to make sure they matched up. I've tried localhost, 127.0.0.1, and the IP address of my server itself for the
Does anyone have any ideas or had this issue before?