Help installing multiple blogs with different domains – same database

I’m a little confused. Is this your third wordpress installation?

Yes. I have two databases, 3 domains.

I’ve installed one wp install on one database and similar for the other…

I now want to host another wordpress site for a different domain.

hth

Kelly

Did you create the third database?

No because I don’t have any other databases in my package.

If I could it wouldn’t be an issue….

Try creating a brand new user and password for your database and add that one to the database as well, then connect your config file with the new user and password. Make sure you get any prefixes to the database and database user. Many hosts have a prefix to the database like something_database. 1and1 may also have limits and/or restrictions on what you can do with a single database. You might want to contact them and see what support they can offer.

Review Installing Multiple Blogs. Essentially you use a different value for $table_prefix in your wp_config.php file…

Thanks!

1and1 don’t offer the ability to add multiple users, I have a feeling that they’ve restricted the option to be able to create additional tables hence the error message.

I’ve changed the $table_prefix in my wp_config.php file and it still doesn’t work…

off to speak to support me thinks!

thanks for all of your help! will come back if I get a solution…

Seems all you would have to do is copy the wp-config.php from one of the two working WordPress installs, then using that with the 3rd install, just set a different $table_prefix value.

that’s exactly what i did. I currenly have a live site and I copied all of the files accross including the wp-config and changed the;

table_prefix = ‘wp_’ to

$table_prefix = ‘kcwp_’

all of the database information is correct, and I’m getting error 403 on my domain name and Error establishing a database connection when i run the /wp-admin/install.php

How weird!

I’ve deleted the wp-config, done the whole process all over again and now I’m getting You appear to have already installed WordPress. To reinstall please clear your old database tables first.

Ok numpty alert!

the setup files had both wp-config and the wp-config-sample I deleted the wp-config-sample and hey presto it worked!! so it was obviously conflicting with each other…or so it seems!!

One happy wordpress customer <does a jiggy dance>

do you want add third tables with different table_prefix in the same database?
I mean that you want use two different wordpress systems, but use only one database. There are wordpress tables with two different table_prefix in one database.
Am i right?
I try this, it works!

Yes you’re right!

and it works! :O)