List:MySQL and Java« Previous MessageNext Message »
From:John Pedersen Date:August 3 2004 10:09pm
Subject:Communication failure during handshake
View as plain text  
Hi,

Since I have installed mysql 4.1 I am getting this error on trying to
reach the db:

java.sql.SQLException: Communication failure during handshake. Is
there a server running on localhost:3306?

Mysql is running OK. I can access it with the command prompt, telnet,
sqlyog, but not Java.

I have tried using mysql-connector-java-2.0.14-bin.jar and
mysql-connector-java-3.1.3-beta-bin.jar. I am sure that the classpath
is OK, the url, user, password etc - I have had it all working with
mysql 4.0 for months, no problems. I just wanted to be able to use
subselects - but if I can't resolve this soon, I will have to return
to 4.0

Can anyone help?

Thanks,

John Pedersen

Win2k,  j2sdk1.4.2_01

From my Ant script:

<property name="db.driver" value="com.mysql.jdbc.Driver" />
<property name="db.url" value="jdbc:mysql://localhost:3306/dbName" />
Thread
Communication failure during handshakeJohn Pedersen3 Aug
RE: Communication failure during handshakeCesar Vega4 Aug
RE: Communication failure during handshakeVictor Pendleton4 Aug
  • Re: Communication failure during handshakeJohn Pedersen4 Aug
    • Re: Communication failure during handshakeMark Matthews4 Aug
  • RE: Communication failure during handshakeIgor Smirnov5 Aug