sqldeveloper and cpanel

i can't access my website mysql db from sqldeveloper.

in cpanel there is an option (Remote Database Access Hosts) which allows one to add IP addresses that can access the db. I have entered my ip address and i have used the % wildcard.

so for instance if my ip address was 12.34.56.78, i have entered my ip address as:

1 - 12.34.56.78

2 - 12.34.56.%

3 - 12.%.%.%

in sqldeveloper i have downloaded and added the mysql third party jdbc driver .jar file (mysql-connector-java-5.1.13-bin.jar).

i have the right user name, password, hostname and port.

so, if my website domain was called www.mysite.com and my username was use开发者_运维知识库r, the username i would use in sqldeveloper would be mysite_user.

and the hostname would be www.mysite.com.

the port i am told via cpanel is 3307.

i bow to any superior knowledge if my assumptions are incorrect.

any help would be appreciated

-- edit --

oh yeah, the error message I get (pretty important!) in sqldeveloper is

Status : Failure - Test failed: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

-- end edit --

I do the same via cPanel but after i connect to my host via SqlYog community edition...

Uniqe differce is the port, i use the standard 3306 port instead a custom port.

Try if it connect: http://code.google.com/p/sqlyog/

It turns out that i did need to use port 3306 but more importantly, my web host needed to make a change on their firewall.

i managed to connect using mysite.com, username, password and port 3306.

thanks @Achilleterzo for your help in the meantime