Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Jul 2009
    Posts
    86

    Default Remotely Connect to MySQL database on cPanel using Java

    I'm trying to allow a java app to connect to a cPanel accounts mysql database but am not sure if I have all the steps and settings correct.

    I've added the remote database access hosts to WHM and cPanel but am not sure of the connection url that the jdbc client needs to access the database

    Is there ports I have to open in addition to the step above?
    Is there a way to get the required jdbc connection string for each database?

  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: Remotely Connect to MySQL database on cPanel using Java

    What is the connection string you are trying currently for the connection? Of note, you'd need to connect to a database user and password for that database user. The database user must already existing in cPanel > MySQL databases area and must already be added to the MySQL database.
    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
    Join Date
    Jul 2009
    Posts
    86

    Default Re: Remotely Connect to MySQL database on cPanel using Java

    Had the database username & password created and had the connection string nearly correct but instead of jdbc:mysql://remoteserver/ I should have had jdbc:mysql://remoteserver/dbname

    The 1st url passed a basic connection test but didn't get to the database when it came time to actually interact with the database

Similar Threads & Tags
Similar threads

  1. Allow any host to connect to MySQL remotely
    By zeez in forum Database Discussions
    Replies: 2
    Last Post: 02-03-2011, 02:07 PM
  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. Will Pay >> Create a MySQL database remotely with cPanel info?
    By Admin_user in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 06-07-2004, 04:15 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube