1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Sharing MySQL dB's among domains

Discussion in 'Plesk for Windows - 8.x and Older' started by rbhaydon, May 25, 2004.

  1. rbhaydon

    rbhaydon Guest

    0
     
    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)
     
  2. paulwilson159

    paulwilson159 Guest

    0
     
    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)
     
Loading...