R
rbhaydon
Guest
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)
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)