Installation DB connection settings


After much fiddling, trial and error etc, im having a real tought time getting the move-blogs.php file to work.

It cant connect to the database and gives the following error: Houston, we have a problem!

Looks like you need to create your new db’s! If you’re lucky, this link still works – click me

Database Error: Access denied for user ‘lfeandy_word’@’localhost’ to database ‘lfeandy_wordpress_d’

I have checked the databases have been created.

Here is a dump from my db-config.php


// Plugin Name: Multi-DB

// Plugin URI:

// Author: Andrew Billits (Incsub)

// Version: 2.9.2



//---DB Scaling




// 16,256,4096

define ('DB_SCALING', '16');



//---DC IPs




// Usage: add_dc_ip(IP, DC)

// EX: add_dc_ip('123.123.123.', 'dc1');

add_dc_ip('', 'dc1');



//---Global Tables




// Do not include default global tables

// Leave off base prefix (eg: wp_)


// Usage: add_global_table(TABLE_NAME)

// EX: add_global_table('something');




//---DB Servers




// Database servers grouped by dataset.

// R can be 0 (no reads) or a positive integer indicating the order

// in which to attempt communication (all locals, then all remotes)


// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)

// EX: add_db_server('global', 'dc1', 1, 1,'','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');


// Note: you can also place this section in a file called db-list.php in wp-content

add_db_server('global', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress', 'myuser', 'mypass');

add_db_server('0', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_0', 'myuser', 'mypass');

add_db_server('1', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_1', 'myuser', 'mypass');

add_db_server('2', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_2', 'myuser', 'mypass');

add_db_server('3', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_3', 'myuser', 'mypass');

add_db_server('4', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_4', 'myuser', 'mypass');

add_db_server('5', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_5', 'myuser', 'mypass');

add_db_server('6', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_6', 'myuser', 'mypass');

add_db_server('7', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_7', 'myuser', 'mypass');

add_db_server('8', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_8', 'myuser', 'mypass');

add_db_server('9', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_9', 'myuser', 'mypass');

add_db_server('a', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_a', 'myuser', 'mypass');

add_db_server('b', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_b', 'myuser', 'mypass');

add_db_server('c', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_c', 'myuser', 'mypass');

add_db_server('d', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_d', 'myuser', 'mypass');

add_db_server('e', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_e', 'myuser', 'mypass');

add_db_server('f', 'dc1', 1, 1,'','localhost', 'lfeandy_wordpress_f', 'myuser', 'mypass');

//add_db_server('vip1', 'dc1', 1, 1,'','', 'wpmu_vip_1', 'db_user_name', 'db_user_name_pass');



//---VIP Blogs




// Usage: add_vip_blog(BLOG_ID, DS)

// EX: add_vip_blog(1, 'vip1');

//add_vip_blog(1, 'vip1');


I have also included my move-blogs.php file:



Plugin Name: Multi-DB (Conversion Tool)

Plugin URI:


Author: Ron Dillehay - FanMail to (no tech support please) - Modified slightly by Andrew Billits (Incsub)

Version: 2.9.2

Author URI:


This script is to move blogs from a wordpress mu single database setup, to a wordpress mu multiple database setup using an MD5 hash to establish blog routing

Use this script at your own risk. My test setup uses php 5, mysql 5, and wordpress mu 1.2.5a








///DB Settilfengs

$dbname = "lfeandy_wordpress"; //This is your current database

$blog_table_prefix = 'wpmu_'; //Prefix of your wpmu blog tables, most likely this won't need to be changed

$newdb_prefix = 'lfeandy_wordpress_'; //This is the prefix of the db's you're moving your tables into - we assume they are all the same, if not, you're in trouble

//We need info to connect to the databases

$dbhost = 'localhost';

$dbuname = 'myuser';

$dbpass = 'mypass';

//How many db's are you moving into (16, 256, or 4096)?

$db_scaling = '16';




And my wp-config.php file:



* The base configurations of the WordPress.


* This file has the following configurations: MySQL settings, Table Prefix,

* Secret Keys, WordPress Language, and ABSPATH. You can find more information

* by visiting {@link Editing

* wp-config.php} Codex page. You can get the MySQL settings from your web host.


* This file is used by the wp-config.php creation script during the

* installation. You don't have to use the web site, you can just copy this file

* to "wp-config.php" and fill in the values.


* @package WordPress


// ** MySQL settings - You can get this info from your web host ** //

/** The name of the database for WordPress */

define('DB_NAME', 'lfeandy_wordpress');

/** MySQL database username */

define('DB_USER', 'myuser');

/** MySQL database password */

define('DB_PASSWORD', 'mypass');

/** 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', '');





* WordPress Database Table prefix.


* You can have multiple installations in one database if you give each a unique

* prefix. Only numbers, letters, and underscores please!


$table_prefix = 'wpmu_';


* WordPress Localized Language, defaults to English.


* Change this to localize WordPress. A corresponding MO file for the chosen

* language must be installed to wp-content/languages. For example, install

* to wp-content/languages and set WPLANG to 'de' to enable German

* language support.


define ('WPLANG', '');


* For developers: WordPress debugging mode.


* Change this to true to enable the display of notices during development.

* It is strongly recommended that plugin and theme developers use WP_DEBUG

* in their development environments.


define('WP_DEBUG', false);

define( 'MULTISITE', true );

define( 'SUBDOMAIN_INSTALL', true );

$base = '/';

define( 'DOMAIN_CURRENT_SITE', '' );

define( 'PATH_CURRENT_SITE', '/' );

define( 'SITE_ID_CURRENT_SITE', 1 );

define( 'BLOG_ID_CURRENT_SITE', 1 );

/* That's all, stop editing! Happy blogging. */

/** Absolute path to the WordPress directory. */

if ( !defined('ABSPATH') )

define('ABSPATH', dirname(__FILE__) . '/');

/** Sets up WordPress vars and included files. */

define( 'SUNRISE', 'on' );

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

Sorry for the huge post, but im all out of ideas and really would like to get this working.

Thanks very much!