Adding a new WordPress site to an Existing Installation

You already have a working WordPress (WP) site.  Now, you need to add one more site with a new MySQL database.  This document describes how to add one more database and install a new WP site on the same server.

Download latest WordPress ZIP package (3.X) and unzip it to your future site location.
Open IIS Admin
Create a new virtual directory pointing to that location

Side Notes – Change root password
You need to know existing root user password. Login into MySQL Command Line Client. Select database:
use mysql;
Reset user password:
update user set password=PASSWORD(“NewPassword”) where User=’root’;
Allpy new password:
flush privileges;

Create a New Database
Use MYSQL Client (command shell)
You need to know your current MySQL root user password
Add a new database –
Do NOT forget ; at the end of each command

Get the list of all users:
SELECT user FROM mysql.user;

Grant access to this new database:
GRANT ALL PRIVILEGES ON Your_DB_Name.* TO “YourUserName”@”localhost”;

Reload grant tables:

Edit    wp-config.php
Rename wp-config-sample.php into wp-config.php
Edit wp-config.php and set these parameters:

Set the table prefix for something suitable to your site:
$table_prefix  = ‘sc_’;

Cofigure Your Site
Point your browser to:
You might see an error:
“Error establishing a database connection”
Check D/B name, user name or password
Try again
See WELCOME screen

WP is now communicating with new MySQL database
Create and Write down your admin site user ID and password
Login with your new credentials
You are done!

(Visited 400 times, 2 visits today)

Be the first to comment

Your question, correction or clarification Ваш вопрос, поправка или уточнение