Help installing multiple blogs with different domains – same database

Resolved kellycairns
(@kellycairns)

14 years, 7 months ago

Hi

I have searched the forums for a solution to my problem. Whilst there are lots of users having the same issue I still haven’t been able to resolve it…

My host is 1and1, and I have 2 databases. I already have an install on each with two different domains.

I am now needing to host another wordpress site using another domain. I have installed the wp files and changed the $table_prefix = ‘wp_’; to $table_prefix = ‘kcwp_’; and have entered all of the database information correctly, I’ve even changed the database password to see if that helps solve it…but I keep getting the error message “Error establishing a database connection”

I’ve deleted the file, typed the database information, copied and pasted the user information and it’s still coming back with the same error!

Please help…I need to get a website up and running and if I can’t resolve it I’ll have to buy another account, which I really don’t want to have to do!…

thanks!

p.s I have spent endless hours trawling google and the help forums here..

Viewing 13 replies - 1 through 13 (of 13 total)

batrachoid
(@batrachoid)

14 years, 7 months ago

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

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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

batrachoid
(@batrachoid)

14 years, 7 months ago

Did you create the third database?

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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

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

bh_WP_fan
(@bh_wp_fan)

14 years, 7 months ago

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.

MichaelH
(@michaelh)

14 years, 7 months ago

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

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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…

MichaelH
(@michaelh)

14 years, 7 months ago

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.

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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.

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

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>

talentluo
(@talentluo)

14 years, 7 months ago

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!

Thread Starter kellycairns
(@kellycairns)

14 years, 7 months ago

Yes you’re right!

and it works! :O)