Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Connecting to remote MySQL from another server

Discussion in 'Database Discussion' started by ipublicis, Dec 27, 2018.

  1. ipublicis

    ipublicis Member

    Joined:
    Apr 27, 2018
    Messages:
    10
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Lisboa, Portugal
    cPanel Access Level:
    Root Administrator
    I have two servers. A with the MySQL server and B with Application.

    In server A I already add the domain app.domain.com has an authorized remote MySQL domain.
    I also already created the DB and DB user.

    Now I need to set the configuration part on the server B script

    Host = ????
    DB_User = serverAuser_username
    Pass = somethingodd
    Database = serverAuser_dbmane

    What shall I put on Host (don't want to use an IP)

    Thanks in advance.
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    You can point a subdomain to the IP and use that if you prefer, though there really isn't a problem with using just the IP.

    Is there a private network between them? Because it would be better for the DB traffic to go over a separate interface.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelLauren likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,456
    Likes Received:
    503
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice