same database for more websites

[Ulitasch]

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 🙂

[Newsgroup_User · Accepted solution]

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/

[Guest]

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.