1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How to share mysql db between domains?

Discussion in 'Plesk for Linux - 8.x and Older' started by jackop, Jan 30, 2006.

  1. jackop

    jackop Guest

    I created a mysql db in domain A, and I now want to access it from domain B.
    How can I do that?
  2. michaellunsford

    michaellunsford Regular Pleskian

    Jul 25, 2005
    Likes Received:
    works fine on my server using PHP. I just select the database as usual using the proper name and password.
  3. DeanW

    DeanW Guest

    Are the domains on the same server? If not you will need to modify the "mysql" database entries on the target server to allow remote access.

    Log in to mysql as admin and run the following commands:

    use mysql;

    update user set Host = '%' where User = 'TargetDB_Username';

    update db set Host = '%' where Db = 'TargetDB_Database';

    flush privileges;

    Also make sure the 3306 port is open on the firewall, at least for the connecting IP. :D