Title: Two installations on single database Last modified: August 19, 2016 --- # Two installations on single database * Resolved [spoondog](https://wordpress.org/support/users/spoondog/) * (@spoondog) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/) * I’m having a problem with admin when installing two blogs on a single database. * I have got brand new hosting with cpanel, and I’m trying to install two blogs into separate folders – [http://www.mysite.com/tennis](http://www.mysite.com/tennis) and [http://www.mysite.com/squash](http://www.mysite.com/squash). I entered separate table prefixes when doing the cpanel install, and everything went smoothly – both blogs show up fine. * However, when I try visit the “Site Admin” link and log in (for either blog), it will display the error “**You do not have sufficient permissions to access this page.**“ * Looking at the wp-config.php files that were created in each directory, they seem to be correct according to [this support page](http://codex.wordpress.org/Installing_Multiple_Blogs). Here are the relevant parts of each wp-config.php file: * ``` define('DB_NAME', 'admin_wp1'); define('DB_USER', 'admin_wp2'); define('DB_PASSWORD', 'xxxxx'); define('DB_HOST', 'localhost'); define('DB_CHARSET', 'utf8'); define('DB_COLLATE', ''); define('AUTH_KEY', 'xxxxx'); define('SECURE_AUTH_KEY', 'xxxxx'); define('LOGGED_IN_KEY', 'xxxxx'); define('NONCE_KEY', 'xxxxx'); $table_prefix = 'tennis_'; define ('WPLANG', ''); ``` * ``` define('DB_NAME', 'admin_wp1'); define('DB_USER', 'admin_wp1'); define('DB_PASSWORD', 'xxxxx'); define('DB_HOST', 'localhost'); define('DB_CHARSET', 'utf8'); define('DB_COLLATE', ''); define('AUTH_KEY', 'xxxxx'); define('SECURE_AUTH_KEY', 'xxxxx'); define('LOGGED_IN_KEY', 'xxxxx'); define('NONCE_KEY', 'xxxxx'); $table_prefix = 'squash_'; define ('WPLANG', ''); ``` * Any idea why this might be happening? Viewing 7 replies - 1 through 7 (of 7 total) * [Micah Cooksey](https://wordpress.org/support/users/micahcooksey/) * (@micahcooksey) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404561) * You might check your FTP permissions. Your folders (as a general rule) should be set to 755, and files (again as a general rule) should be set to 644. * Thread Starter [spoondog](https://wordpress.org/support/users/spoondog/) * (@spoondog) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404591) * Checked permissions and all folders are currently 755, files 644. * Also checked the database permissions and both users have access to all DB operations. * Thanks for the reply. * Thread Starter [spoondog](https://wordpress.org/support/users/spoondog/) * (@spoondog) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404872) * Anyone else have any ideas? Seems like it should be something very simple :/ * [christian_gnoth](https://wordpress.org/support/users/christian_gnoth/) * (@christian_gnoth) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404873) * htaccess????? * you can also use wordpress mue * [http://mu.wordpress.org/](http://mu.wordpress.org/) * [henkholland](https://wordpress.org/support/users/henkholland/) * (@henkholland) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404874) * Hi, * in your tennis wp-config.php it says this: * ``` define('DB_NAME', 'admin_wp1'); define('DB_USER', 'admin_wp2'); ``` * and that should be: * ``` define('DB_NAME', 'admin_wp1'); define('DB_USER', 'admin_wp1'); ``` * bit I guess it’s a typo. * You only have one DB so admin and user for the DB should be identical in Squash and Tennis. * Thread Starter [spoondog](https://wordpress.org/support/users/spoondog/) * (@spoondog) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404886) * Thank you for the replies guys! * I’ve narrowed it down to the table prefix now (not multiple installations) but still not sure what the problem is. - If I install a **single blog** on a new DB with the default “wp_” as the table prefix, it works fine. - If I install a **single blog** on a new DB but change the prefix to “wp1_”, then I can’t log in to the admin area, even though wp-config.php has “$table_prefix = ‘wp1_’;” in it! * I don’t get it! *_* * Thread Starter [spoondog](https://wordpress.org/support/users/spoondog/) * (@spoondog) * [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404897) * Yay! Thanks to another thread that linked to [this page](http://beconfused.com/2007/08/28/how-to-solve-you-do-not-have-sufficient-permissions-to-access-this-page-in-wordpress/), I solved my problem. * Some keys in the database needed their prefix changed manually, as they were still “wp_”. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Two installations on single database’ is closed to new replies. ## Tags * [installation](https://wordpress.org/support/topic-tag/installation/) * [multiple](https://wordpress.org/support/topic-tag/multiple/) * [permissions](https://wordpress.org/support/topic-tag/permissions/) * [sufficient](https://wordpress.org/support/topic-tag/sufficient/) * [wp-config](https://wordpress.org/support/topic-tag/wp-config/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 7 replies * 4 participants * Last reply from: [spoondog](https://wordpress.org/support/users/spoondog/) * Last activity: [16 years, 3 months ago](https://wordpress.org/support/topic/two-installations-on-single-database/#post-1404897) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics