Hi Friends, Multiple WordPress Installation into a single database. is it possible and how difficult is it?

This question is arrive when we think about installing multiple WordPress but our server(Host) has a limit of the MYSQL Database. The simple answer to this question is “Multiple WordPress Installation into a single database is possible and it’s not so difficult.”

For installing multiple WordPress on single MYSQL Database we need to install WordPress manually not using one-click programs they would not let you choose the prefix.

Please read here for manually installing WordPress if you don’t know if you already know its good. When we follow WordPress installation steps WordPress will for database pieces of information like in the below image.

WordPress Table Prefix

We need to enter all the details related to the database here only thing we need to change is Table Prefix. By default, the WordPress table prefix is (wp_). We can change it according to our requirement like below.

  1. For the Main website (www.example.com)
    We can use table prefix (main_)

  2. For Subdirectory blog (www.example.com/blog)
    We can use table prefix (blog_)

  3. For Subdomain blog (www.blog.example.com)
    We can use table prefix (blog2_) or anything that differentiates our table columns.

By using Table Prefix we can install as many WordPress we want on a single MYSQL Database.

Step 1

Download WordPress from https://wordpress.org/download.

Step 2

Extract files where you want to install WordPress like:

Here wordpress is a folder inside the htdocs folder.

  • On Server – https://yourdomain.com/

Here your WordPress is installing in root folder on server.

  • On Server sub domain  – https://yourdomain.com/blog

Here blog is a folder inside your root folder on server.

Step 3

Create database on your localhost (phpmyadmin) or on server where you extract your folder.

On localhost there is default user is root and password is blank.

On Server you need to create a User. View all instruction for creating database on cpanel.

After creating database and user, copy all details on notepad like database name, user name, user password and server URL.

Step 5

Open your domain on browser

  • On localhost – http://localhost/wordpress
  • On Server – https://yourdomain.com/
  • On Server sub domain  – https://yourdomain.com/blog/

and follow the instructions:

Step 5.1

Select language:

Step 5.2

Prepare all details we need to install WordPress as mention in screenshot:

Step 5.3

Enter all details which ask, on local your Host is localhost and on server your host may be different or may be localhost:

Step 5.4

Enter all details which ask, please enter valid Email so that if you forgot your password you can reset using email:

That’s all now your WordPress is install and running you can login and start customization.

How to Install XAMPP and WordPress Locally on PC/Windows in Hindi – AK Maurya

What is XAMPP?

XAMPP stands for cross-platform, Apache, MySQL, PHP and Perl. It’s a simple and lightweight solution that allows you to create a local web server for testing purposes.

What is WordPress?

WordPress is an online, open source website creation tool written in PHP. But in non-geek speak, it’s probably the easiest and most powerful blogging and website content management system (or CMS) in existence today.

Follow the steps below :

  • Go to the https://www.apachefriends.org/index.html and download XAMPP.
  • Install XAMPP on your system
  • Start up both Apache and MySQL in XAMPP control panel.
  • Download the latest version of WordPress. https://wordpress.org/download
  • Go to the XAMPP folder on your computer and open the htdocs folder – C:/XAMPP/htdocs. and page your WordPress files.
  • find the wp-config-sample.php file and rename it wp-config.php.
  • open in browser http://localhost/phpmyadmin
  • create a new data base and copy its name and enter in wp-config.php file.
  • Replace “username_here” with “root” and leave “password_here” blank, Save the file and close it.
  • Open your browser and go to http://localhost/your wordpres folder name/
  • chosen your language, continue onto the next screen and enter you username and password details. Click Install WordPress.
  • Your WordPress installation is now complete!