Sean Breslin wrote:
> Thank you, that link has helped me understand how
> this works. The problem, however, was that my
> router was blocking the port I tried to connect
> on... Incredibly stupid mistake.
>
> Now that I'm not having that problem, I'm getting
> the other message that I mentioned when I tried
> another ISP...
>
> Here are the lines of code creating the error:
>
> String connString =
> "jdbc:mysql://myurl.com:6998/dbname?user=user&
> password=pass&useUnicode=true&characterEnc
> oding=UTF-8";
> conn = DriverManager.getConnection(connString);
>
> And the error created:
>
> Communications link failure due to underlying
> exception:
Sean,
Sounds like the port is blocked by a firewall. Most ISPs/providers that have MySQL servers _don't_ have them open to the internet, you can only connect locally on the machine the database is hosted on (or within the DMZ).
-Mark
Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html