JDBC MYSQL Database Problem - Communications link failure

Question

0.00/5 (No votes)

See more:

Okay I currently have a database on my local machine (localhost) and it connects fine using the current code.
I can access my database fine, and load data from it.

I transferred this database onto a server online.

I change the code from:

Java

static final String URL = "jdbc:mysql://localhost:3306/";

to...

Java

static final String URL = "jdbc:mysql://fdb3.atspace.com:3306/";

I changed the username and the password too, and I seem to get this error:

Java

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

I am unsure how to resolve it.
Can anyone help me?

Posted 29-Dec-11 13:09pm

Willtwinny

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Answer 1 · 2011-12-29T14:33:00

Solution 1

Can you connect to the server using http://www.mysql.com/products/workbench/[^]

My guess is that you're having problems with a firewall.

Best regards
Espen Harlinn

Posted 29-Dec-11 14:33pm

Espen Harlinn

Comments

Willtwinny 30-Dec-11 12:20pm

Sorry I am not very clear. I can connect to the server on my machine (localhost), however if I want to use my software on another machine then I would need to set up the server on that machine in order to use it.

Therefore to avoid doing having to do this, I have uploaded the mysql database to an online server and I want to connect that server (fdb3.atspace.com) however I seem to receive this error.

I have disabled my firewall and I still get the same error.

Espen Harlinn 31-Dec-11 5:13am

And you can connect to the MySQL server on fdb3.atspace.com using the workbench?

Willtwinny 1-Jan-12 16:52pm

No I can't seem to connect to the MySQL server using the workbench.
I have contacted the company (atspace.com), and got a unhelpful response so I am going to try and contact them again. I think it may be a problem with the atspace.com server?

What are your thoughts?