Multiple WordPress Installation Using a Single Database

Posted on August 10th, 2009 by in Beginners Guide | 5 Comments  
Multiple WordPress Installation Using a Single Database

Sometimes there are more than one WordPress installation is necessary, but your host might have limited MySQL Database allowance. Well the solution to that problem is having multiple WordPress installation in one database.

You must install WordPress manually in order for this to work. Most one click programs like Fantastic would not let you choose the prefix.

During the installation in your config.php phase, you want to change the prefix “wp_” in order to allow multiple installation. So it can be wpchris_ and the next one can be wpben_ you can use different prefix and use them to create as many installation as you need.

Multiple Blog Installation

That is all you really need to do. This is also a security measure that you can take even if you don’t have to install multiple installation. By having a prefix, you are making the hacker work more to find out what is the SQL Address before he can hack.

About

Editorial Staff at WPBeginner mainly Syed and David.

Post comment as twitter logo facebook logo
Sort: Newest | Oldest

I want to atach two wordpresses with single user table.
I mean if a user gets registered to one of em he can have excess to both of 'em !

Use WordPress Multi-Site option. That will accomplish what you are looking for.

its not working , i still facing problem because i need single user to access the whole installation once

Tweets about us: