Weird database error when multisite is activated in wp-config

Hi All – any help you can give me would be much appreciated.

I developed an MU site using the ip address of the hosting and the entire site went up fine with absolutely no issues at all.

But then after I switched the nameservers over for their domain and changed the wp-config file to the new domain address – I now get error connecting to database issues everytime I try to bring it up.

Deactivating the multisite portion of the wp-config fixes the connection error I get but then I don’t have any of the other sites obviously and a bunch of MU only plugins don’t work.

This has been driving me to the deepend and I have no idea what could be wrong with it.

This was my wp-config before the switch (db info has been changed for security):

define('DB_NAME', 'DB');

define('DB_USER', 'User');

define('DB_PASSWORD', 'Password');

define('DB_HOST', 'localhost');

define('DB_CHARSET', 'utf8');

define('DB_COLLATE', '');

define('AUTH_KEY', 'put your unique phrase here');
define('SECURE_AUTH_KEY', 'put your unique phrase here');
define('LOGGED_IN_KEY', 'put your unique phrase here');
define('NONCE_KEY', 'put your unique phrase here');
define('AUTH_SALT', 'put your unique phrase here');
define('SECURE_AUTH_SALT', 'put your unique phrase here');
define('LOGGED_IN_SALT', 'put your unique phrase here');
define('NONCE_SALT', 'put your unique phrase here');

$table_prefix = 'wp_';

define ('WPLANG', '');

define('WP_DEBUG', false);

/* multi site config
define('WP_ALLOW_MULTISITE', true);

define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', false );
$base = '/~mommycon/';
define( 'DOMAIN_CURRENT_SITE', '66.147.244.220' );
define( 'PATH_CURRENT_SITE', '/~mommycon/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

if ( !defined('ABSPATH') )
define('ABSPATH', dirname(__FILE__) . '/');

require_once(ABSPATH . 'wp-settings.php');

After the domain switch I only changed the following lines under the multisite portion

/* multi site config
define('WP_ALLOW_MULTISITE', true);

define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', false );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'www.mommyconnections.ca' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

And nothing I have done seems to work – it’s dirving me bananas!

Why would it work fine using the ip address and now won’t work at all with the domain?

My host is Bluehost and when I talked to them they just said it was an issue with the wp-config and pointed me towards the WordPress forums.

Any help you guys could give me would be much appreciated!