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!

Allow any host to connect to MySQL remotely

Discussion in 'Database Discussion' started by zeez, Feb 2, 2011.

  1. zeez

    zeez Registered

    Joined:
    Jan 13, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    I have some system that requires connecting to my MySQL DB from anywhere in the world (No specific place, so random IPs). I'm trying to setup "Remote Database Access Hosts" in a way to accept connections from whatever IP, but it won't accept using something like %.%.%.% or %.
    For my requirements it is basically impossible to list every possible IP, so I need someway to allow any host to be able to connect to MySQL (of course, using username and password I specify).
    Is that possible?

    Thank you
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If this is just databases on one cPanel account, then you can allow the connection from any IPs by using the % (wildcard) in cPanel > Remote MySQL area. It isn't advisable to simply allow it to connect to MySQL itself for every database ever created and that will be created for every user. As such, you would need to add this on specific user accounts instead, which would allow access to all existing and future existing databases for that set user.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. coderiser

    coderiser Member

    Joined:
    Jan 31, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    some hosts might disable the remote mysql functionality so you may need to talk with your 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