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 DB_NAME. Nothing.
Does anyone have any ideas or had this issue before?
