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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Setup Remote MySQL Server - public or private ip?

Discussion in 'Database Discussions' started by morrow95, Sep 27, 2015.

  1. morrow95

    morrow95 Well-Known Member

    Joined:
    Oct 8, 2006
    Messages:
    106
    Likes Received:
    2
    Trophy Points:
    168
    I have a dedicated vm for our database operation. I am confused as to what needs to be done in 'Home > SQL Services > Setup Remote MySQL Server' to accomplish this.

    Setup goes something like this :

    server.example.com (where WHM is)
    IP: 111.111.111.111 NAT'd > 192.168.10.3

    db.example.com (all database)
    IP: 222.222.222.222 NAT'd > 192.168.10.2

    It appears WHM assumes you will always use a public IP for this setup, but can I accomplish this with a private IP?

    I am following https://documentation.cpanel.net/display/1150Docs/Setup+Remote+MySQL+Server, but it doesn't get into anything like this.
     
  2. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    596
    Likes Received:
    92
    Trophy Points:
    153
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    Yes you can, did you have any specific questions regarding why you think you cannot use a private IP
     
  3. morrow95

    morrow95 Well-Known Member

    Joined:
    Oct 8, 2006
    Messages:
    106
    Likes Received:
    2
    Trophy Points:
    168
    Got it figured out - had a few things that needed corrected before it would complete.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,371
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    I am happy to see it's now working as expected. Thank you for updating us with the outcome.
     
Loading...

Share This Page