Skip to main content
U
Ulitasch
Participating Frequently
January 15, 2008
Answered

same database for more websites

  • January 15, 2008
  • 2 replies
  • 401 views
I want to make 6 websites with different domeinnames (but under the same host) with the same database (MySQL), so that I just have to update the 1 database and all 6 websites will be updated.
But how do I do this? When I use one database login as Connection for a website which isn't its database .. then I get the message "Can't connect to MySQL server". So when I cannot use the same database because I cannot connect to it, can I send datas to 6 different databases or is there a more easy way?

Thanks a lot for helping me out 🙂
This topic has been closed for replies.
Correct answer Newsgroup_User
Ulitasch wrote:
> When I use one database login as Connection for a
> website which isn't its database .. then I get the message "Can't connect to
> MySQL server".

This is a security policy that will have been set up by your hosting
company. It's quite sensible when you think about it, because you
wouldn't want other users of the same server to have access to any of
your databases.

The simplest solution - as long as your hosting company agrees to do it
- would be to ask the server administrator to create a master user
account that has access to a single database from all six domains.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

2 replies

A
Anonymous
January 15, 2008
I have many web sites (domains) using the same MySQL database.

Easist way to get it working is use a Virtual Private Server (VPS) from your host. Move all your domains to the VPS and you are good to go. If your host doesn't offer this you can try a different host. Network Solutions offers a VPS for $99/month.
N
Newsgroup_UserCorrect answer
Inspiring
January 15, 2008
Ulitasch wrote:
> When I use one database login as Connection for a
> website which isn't its database .. then I get the message "Can't connect to
> MySQL server".

This is a security policy that will have been set up by your hosting
company. It's quite sensible when you think about it, because you
wouldn't want other users of the same server to have access to any of
your databases.

The simplest solution - as long as your hosting company agrees to do it
- would be to ask the server administrator to create a master user
account that has access to a single database from all six domains.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices