Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Jan 2010
    Posts
    3

    Default Allow any host to connect to MySQL remotely

    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. #2
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    6,305
    cPanel/Enkompass Access Level

    Root Administrator

    Default Re: Allow any host to connect to MySQL remotely

    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.
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Forums Technical Analyst, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  3. #3
    Member coderiser's Avatar
    Join Date
    Jan 2011
    Posts
    18

    Default Re: Allow any host to connect to MySQL remotely

    some hosts might disable the remote mysql functionality so you may need to talk with your provider

Similar Threads & Tags
Similar threads

  1. Remotely Connect to MySQL database on cPanel using Java
    By mobcdi in forum Database Discussions
    Replies: 2
    Last Post: 08-10-2011, 04:25 AM
  2. Allow any host to connect to MySQL remotely
    By zeez in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-02-2011, 06:35 AM
  3. Remotely connect to MYSQL?
    By azz0r in forum Database Discussions
    Replies: 2
    Last Post: 05-12-2008, 09:34 PM
  4. Cant connect to database remotely.
    By BianchiDude in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 11-22-2006, 01:29 PM
  5. cannot connect remotely
    By kaya in forum New User Questions
    Replies: 1
    Last Post: 11-18-2005, 10:25 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube