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!

Unable to Connect to MySQL Database from my Java app

Discussion in 'Database Discussion' started by aparsharma, Sep 19, 2011.

  1. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    I am facing an issue with connecting my J2EE application with the MySQL on CPanel.
    I tried to connect the MySQL database with SQLYog also, but i am facing the issue Error: 2003 (Can't Connect to MySQL server on ....my IP or domain (10060))

    I did the things that should be done like

    - Add the User to the mySQL database on CPanel
    - Add the % wildcard to the Remote MySQL Access Hosts
    - I verified the username and password too

    I am using the following parameters in my J2EE application while connecting...

    - Host name is Shared IP as given in the Shared IP Address on the CPanel Home page( I am not sure if this is
    correct, else I dont know how to get the Host name from CPanel)
    - Database name is Cpaneusername_mydatabasename
    -     Database password is my custom password
    - Database Url is jdbc\:mysql\://<MyDomain or Host name>\:3306/<MyDatabaseName on Cpanel>


    I don't know how to proceed further on this.

    Thanks,
    Apar
     
    #1 aparsharma, Sep 19, 2011
  2. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    is your J2EE application and MySQL database is on different server? if no then try to use localhost as Hostname.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 milind, Sep 19, 2011
  3. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Hi Milind,

    Thanks for the reply.
    My J2EE application is on my local machine.
    And I am connecting from my local to the MySQL database on the CPanel.

    Thanks,
    Apar
     
    #3 aparsharma, Sep 19, 2011
  4. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Can you please try telnet <mysql host IP> 3306 from command prompt of your local machine?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 milind, Sep 19, 2011
  5. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Hi Milind,

    I did telnet for the IP and the domain both

    Its returning the following error (in case of IP below)

    Connecting To xxx.xxx.0.60 Could not open connection to the host, on port 3306: Connect failed

    Thanks,
    Apar
     
    #5 aparsharma, Sep 19, 2011
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Do you have a firewall running? It might be blocking port 3306 incoming on the server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelTristan, Sep 19, 2011
  7. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    I have to connect to the server which is hosting MySQL. It runs CPanel on it.

    I do not have access to their servers. I dont know if they are running firewall.

    Though I can do Http tunneling and connect from SQLYog but not through a j2ee app.

    Also, It may be possible I am giving a wrong Host IP.

    Please tell me how to find the correct host IP running CPanel.

    I did ping <mydomain>.com, and it gave me an IP which is the same as Shared IP that can be seen from the left hand side information on the CPanel home page. Is that correct?

    When i go to my hosted mySQL database from Cpanel, the Url is something like <mydomain>:2082/.....

    Does it mean i have to go through port 2082 first and then go to 3306.
     
    #7 aparsharma, Sep 19, 2011
    Last edited: Sep 19, 2011
  8. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Please contact your hosting company with the error you are getting.

    I don't think so because in most of the cases domain and database is hosted on same server but might be your hosting company allowing access on port 3306 through a particular IP only (again this is related to firewall).

    No its not like that, you will able to connect directly to port 3306 without any problems once the problem is fixed.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 milind, Sep 20, 2011
  9. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Thanks for the reply.

    I have the domain hosted on a different server and its pointing to the CPanel server which has MySQL.

    Since I am using the Host IP of the Cpanel server to connect, should it make any difference.

    So, I have to check with the administrator of the Cpanel server, whether they are running firewall or not.
     
    #9 aparsharma, Sep 20, 2011
  10. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Yes, you need to contact the provider of the cPanel machine to ask whether they have port 3306 opened for incoming connections. They also need to have a connector (jdbc or whatever) for your application to work with MySQL. If they don't have that connector on the machine, you won't be able to get the application to connect whether port 3306 is opened or not. These are all questions that should be directed to the provider of the server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelTristan, Sep 20, 2011
  11. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Thanks for the reply.
    I will contact the server admin.
     
    #11 aparsharma, Sep 20, 2011
  12. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Please let us know if your problem is fixed or not (if possible let us know the problem) as it will help everyone here as well :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 milind, Sep 21, 2011
  13. aparsharma

    aparsharma Member

    Joined:
    Sep 19, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Hi Milind,

    Sure! For everyone who would have the same problem.

    I contacted the server admin who is hosting CPanel. I mailed him asking why I am not able to connect my Java application to
    the mySQL hosted on CPanel.

    He replied saying that, Remote mysql access is disabled because of security reasons.
    I am following up with the admin of the server there to provide me some kind of access to MySQL.

    Anyway, this did not come out to be a CPanel issue. And, I am thankful to Milind and CpanelTristan for replying diligently.

    Thanks again!!!
    I may bother you guys again in the future!:)
     
    #13 aparsharma, Sep 21, 2011
  14. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Anytime mate :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 milind, Sep 23, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Unable Connect MySQL
  1. alandioda

    Unable to connect to my mysql database

    alandioda, Oct 8, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    1,106
    cPanelMichael
    Oct 9, 2017
  2. efuzone

    Unable to establish master SSH connection Rsync Error

    efuzone, Mar 3, 2019, in forum: Data Protection
    Replies:
    1
    Views:
    146
    cPanelLauren
    Mar 5, 2019
  3. mohamed shahen

    unable to connect to host

    mohamed shahen, Nov 1, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    122
    cPanelLauren
    Nov 2, 2018
  4. Levern Rothwell

    Unable to connect to the database error

    Levern Rothwell, Aug 24, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    518
    Levern Rothwell
    Aug 27, 2018
  5. DevTeam9200

    cPanel accounts unable to use SMTP Send connectors

    DevTeam9200, Jan 29, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    705
    cPanelMichael
    Jan 30, 2018

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.
    Accept Learn More...
    Dismiss Notice