Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

Multiple WordPress Installation Using a Single Database

Last updated on by
Special WordPress Hosting offer for WPBeginner Readers
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.


Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »

Comments

  1. Rim B. says:

    Hello,

    But if I have the choice (unlimited database allowed), is it better to create a new database for each of my websites or this method is yhe best?

    Thank you!!

    • WPBeginner Support says:

      If you can create multiple database, then it is better to keep each WordPress site on a separate database.

  2. ahmad awias says:

    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 !

  3. rasha says:

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

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.