Shouldn't port number 3306 be omitted when communicating with localhost? I believe only
"localhost" is sufficient; and 3306 might cause that error. Am I wrong?
Victor Pendleton <VPendleton@stripped> wrote:Which version of MySQL 4.1 are you
using?
-----Original Message-----
From: Cesar Vega
To: java@stripped
Sent: 8/4/04 9:26 AM
Subject: RE: Communication failure during handshake
Did you defined the mysql-connector-java-2.0.14-bin.jar in the
CLASSPATH?
Another solution is to copy the jar file in JAVA_HOME\jre\lib\ext
>From: John Pedersen
>To: java@stripped
>Subject: Communication failure during handshake
>Date: Tue, 3 Aug 2004 21:09:27 +0100
>
>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:
>
>
>
>
>--
>MySQL Java Mailing List
>For list archives: http://lists.mysql.com/java
>To unsubscribe:
http://lists.mysql.com/java?unsub=1
>
_________________________________________________________________
Charla con tus amigos en lhttp://messenger.latam.msn.com/
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:
http://lists.mysql.com/java?unsub=1
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=1
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
