Sharing MySQL dB's among domains

[rbhaydon]

One of my customers wishes me to host multiple domains on a common Plesk 6.5 server that share a common MySQL database, yet I seem to be unable to share a common MySQL dB across domains -- at least one created using PLESK Admin. Each Plesk-created MySQL dB seems only accessible by that dB.

What I have done so far is:

1. Create MySQL dB under Domain "A", and create a username to access it. All is well & works under Domain "A".

2. Under Domain "B" (on the same Plesk 6.5 server), I modify the "global.php" file in the "httpdocs" folder to include a reference to this database created in Domain "A", using the same username & Password. It is denied access...


Does Plesk 6.5 not use "global.php" files to access databases? Is there a way to bypass this control mechanism so that a Plesk-created MySQL database can be shared amongst domains using a common username? Should I create another instance of MySQL running on the Plesk Server that is NOT controlled by Plesk (seems complex...)?

I guess one solution is to host MySQL on another server, but that is not really solving the problem.

Any ideas?

Thanks,
Bruce
Ottawa, Canada

(apologize if this appeared on the other Plesk 6.5 forum)

 

[paulwilson159]

Why not try rigging up a separate phpMyAdmin and sort out the permissions from there? I know you can set up one on Windows -we did before we installed Plesk. The only catch is that you would need a authentication config file, or use cookie mode, as the http auth method won't work on anything other than Apache (and hates IIS)