WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
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

WPBeginner» Blog» Beginners Guide» Multiple WordPress Installation Using a Single Database

Multiple WordPress Installation Using a Single Database

Last updated on June 21st, 2012 by Editorial Staff
12 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
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.

12 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • How to Properly Move Your Blog from WordPress.com to WordPress.org

  • Checklist

    Checklist: 15 Things You MUST DO Before Changing WordPress Themes

  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

  • How to Fix the Error Establishing a Database Connection in WordPress

    How to Fix the Error Establishing a Database Connection in WordPress

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

12 Comments

Leave a Reply
  1. Srihari says:
    Oct 29, 2017 at 2:04 am

    How to execute multisite global search for multisite installations.Anyone please help me .

    Reply
  2. mohamed amin says:
    Oct 26, 2017 at 9:46 pm

    i want to Installation Multiple WordPress in my Database What is the best hosting company. To applying this can you help me please

    Reply
  3. Niele says:
    Aug 27, 2017 at 3:31 pm

    Hi, what if I want to share woocommerce data?
    For example
    Site A is for regular customer.
    Site B for stockist and agent.
    Do you have any better solution than sharing product /woocommerce database?

    What I have now, multisite (subdomain) install.
    woocommerce dynamic pricing plugin installed by developer (no update). And quite alot of plugins paid and free.

    So it’s outdated and spitting problems and error in log.

    Reply
  4. Rim B. says:
    Feb 8, 2014 at 6:47 pm

    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!!

    Reply
    • WPBeginner Support says:
      Feb 9, 2014 at 9:37 pm

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

      Reply
      • Rik says:
        Jul 11, 2019 at 4:54 pm

        Why? Not disagreeing, just wondering if you have any reasoning behind this opinion.

        Reply
        • WPBeginner Support says:
          Jul 12, 2019 at 11:12 am

          WordPress by default is designed to have one database per site and having multiple sites on a single database means if there is ever trouble with that single database you’re troubleshooting both a large number of sites and a custom setup.

  5. ahmad awias says:
    Jan 21, 2011 at 4:59 pm

    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 !

    Reply
    • Editorial Staff says:
      Jan 24, 2011 at 10:16 am

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

      Reply
      • Amir says:
        Jan 30, 2019 at 3:49 pm

        Wouldn’t the multisite be an overkill if it’s only 5-10 different websites?

        Reply
        • WPBeginner Support says:
          Jan 31, 2019 at 10:49 am

          Multisite’s functionality would be for connecting the users table, multisite can handle a small number of sites as well as a large number.

  6. rasha says:
    May 31, 2010 at 2:43 pm

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

    Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
SeedProd Logo
SeedProd
Create beautiful custom landing pages - Drag & drop builder. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2020 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2020)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2020)
    • SiteGround Reviews from 4196 Users & Our Experts (2020)
    • Bluehost Review from Real Users + Performance Stats (2020)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2020 – Step by Step Guide
Deals & Coupons (view all)
Weglot Coupon
Get 15% OFF on Weglot multilingual plugin for WordPress.
PanKogut
PanKogut Coupon
Get 20% OFF on PanKogut's premium WordPress themes collection.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).
Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress CDN by MaxCDN | WordPress Security by Sucuri.