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!

MySQL remote whitelisting server-wide

Discussion in 'Database Discussion' started by ashworth102680, May 11, 2015.

  1. ashworth102680

    ashworth102680 Active Member

    Joined:
    May 3, 2007
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    153
    We have a need to enable (open up) remote connections to a certain list of IP addresses to all domains on a particular cPanel server. In the past, we've does this under each cPanel account individually. However, the third party that we need to give access to frequently adds new IPs.

    We're notified of these IP addresses, but it's a major chore to login to each and every account on the server to add new IP addresses. Is there some way we can allow a list of remote IP addresses server-wide so we don't have to do this on a per-account basis? It would save a ridiculous amount of time administering this server.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    You can use:

    "WHM Home » SQL Services » Additional MySQL Access Hosts"

    Per our documentation:

    This interface allows you to permit remote hosts (servers) to access MySQL® databases on your server, or to access a remote MySQL server that you configured via WHM's Setup Remote MySQL Server interface(Home >> SQL Services >> Setup Remote MySQL Server). The system applies this list of servers to every cPanel user and every MySQL user that a cPanel user owns.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    ashworth102680 likes this.
  3. ashworth102680

    ashworth102680 Active Member

    Joined:
    May 3, 2007
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    153
    You. ROCK!!

    Thank you. I knew this had to be possible!
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    I am happy to see that option is what you were looking for. Thank you for updating us with the outcome.
     
    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