Unable to Connect to MySQL Database from my Java app

[aparsharma]

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

 

[milind]

is your J2EE application and MySQL database is on different server? if no then try to use localhost as Hostname.

 

[aparsharma]

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

 

[milind]

Can you please try telnet <mysql host IP> 3306 from command prompt of your local machine?

 

[aparsharma]

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

 

[cPanelTristan]

Do you have a firewall running? It might be blocking port 3306 incoming on the server.

 

[aparsharma]

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.

 

[milind]

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

Please contact your hosting company with the error you are getting.

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

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).

Does it mean i have to go through port 2082 first and then go to 3306.

No its not like that, you will able to connect directly to port 3306 without any problems once the problem is fixed.

 

[aparsharma]

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.

 

[cPanelTristan]

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.

 

[aparsharma]

Thanks for the reply.
I will contact the server admin.

 

[milind]

Thanks for the reply.
I will contact the server admin.

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

 

[aparsharma]

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!

 

[milind]

I may bother you guys again in the future!

Anytime mate